David Onken
asked on
SQL case if field has a space?
Hi. The code below works. The problem that I have is that there are some parts that have a space in the Revision_ID field. If there is a space I would like it to put REV. - in the field. How can I use a case to filter these?
CASE(REVISION_ID)
WHEN NULL THEN ' REV. -'
ELSE ' REV. ' + REVISION_ID
END
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I believe you tried my solution, which won't quite work as WHEN NULL doesn't quite work as expected..
Try Brandon's solution (24110103) which should work..
Try Brandon's solution (24110103) which should work..
ASKER
Thanks for your help today.
ASKER