Posted by chudson007 on 09/05/05 19:42

With the syntax below, why is field1a not "A" if field1 does not
contain "_"



SELECT Field1a = CASE WHEN (field1 LIKE '%_%') THEN (charindex('_',
field1)) ELSE 'A' END, field1
FROM [Table1]

• Next in forum: Re: Problem with case statement
• Prev in forum: Reporting Services - Crystal to SSRS
• Thread view: Problem with case statement

[Reply to this message]