Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.9K
1 Posted Topic
Hi Folks, Just a quickie - can wildcards be used in CASE statements? I have inherited some code and wondered if this: [code] (case substring(anownedby,0,charindex('/',anownedby)) when '2361' then 'GOD' when '2361c' then 'GOD' when '2361d' then 'GOD' when '6206252' then 'BIL' when 'bil' then 'BIL' else 'XXX' end) as branch …
The End.