creating an exception in a statement

[#1]

Hi all,

I'm stuck on this problem.. I'd like to create an exception within my script. eg. (something along these lines)

if(username = 'USER', null(), username [except] where ramsno = '1234') as UserName

I'm sure you can see what i'm trying to do, is there any syntax etc that i can use instead of [except] in the example above? Is this possible?

[vgutkovsky · Accepted solution]

Richard,

Try this:

if(username = 'USER', null(), if (ramsno='1234',null(),Username)) as UserName

. The second null() could be replaced by something else if you want a different action to be taken should ramsno=1234...

Regards,

[#3]

Thanks Vlad, perfect...