How exactly is not not working? A syntax error? Wrong results? If
you post the SELECT, preferably with table definitions, someone might
be able to help.
Roy
[quoted text, click to view] On Thu, 4 Jan 2007 09:52:23 -0000, "Vayse" <vvv> wrote:
>Thanks not working for me. I'm putting the statement the Column part of a
>view. I'm guessing I should be doing something else?
>
>
>"Barry" <barry.oconnor@manx.net> wrote in message
>news:1167840242.856866.94210@n51g2000cwc.googlegroups.com...
>> Hi,
>>
>> You need to use the CASE statement.
>>
>> e.g
>>
>> Select Case
>> When @ClientAge <= 12 Then 'N'
>> Else 'E'
>> End
>>
>> HTH
>>
>> Barry
>>
Thanks not working for me. I'm putting the statement the Column part of a
view. I'm guessing I should be doing something else?
[quoted text, click to view] "Barry" <barry.oconnor@manx.net> wrote in message
news:1167840242.856866.94210@n51g2000cwc.googlegroups.com...
> Hi,
>
> You need to use the CASE statement.
>
> e.g
>
> Select Case
> When @ClientAge <= 12 Then 'N'
> Else 'E'
> End
>
> HTH
>
> Barry
>
Thanks guys, got it working now.
[quoted text, click to view] "Roy Harvey" <roy_harvey@snet.net> wrote in message
news:s6spp25vrg0nu0juvhektcsp46psi7f726@4ax.com...
> How exactly is not not working? A syntax error? Wrong results? If
> you post the SELECT, preferably with table definitions, someone might
> be able to help.
>
> Roy
>
> On Thu, 4 Jan 2007 09:52:23 -0000, "Vayse" <vvv> wrote:
>
>>Thanks not working for me. I'm putting the statement the Column part of a
>>view. I'm guessing I should be doing something else?
>>
>>
>>"Barry" <barry.oconnor@manx.net> wrote in message
>>news:1167840242.856866.94210@n51g2000cwc.googlegroups.com...
>>> Hi,
>>>
>>> You need to use the CASE statement.
>>>
>>> e.g
>>>
>>> Select Case
>>> When @ClientAge <= 12 Then 'N'
>>> Else 'E'
>>> End
>>>
>>> HTH
>>>
>>> Barry
>>>
>>
