Is there a 'not equal too' symbol in TSQL case's

[PreacherUK]

I'd like to do something like


Select CASE (field1)
WHEN <> 9 THEN FIELD1
ELSE ' '
END AS IDTYPE1

TSQL does not like this syntax Am I missing something obvious that my tired eyes are not seeing?

 

[Pattycake245]

Why not just reverse it. I don't think you can do it the other way.

Select CASE (field1)
WHEN = 9 THEN ''
ELSE FIELD1
END AS IDTYPE1

tIM

 

[dbomrrsm]

Select CASE
      WHEN  (field1) != 9 THEN FIELD1
      ELSE ' '
END AS IDTYPE1

[blue]DBomrrsm[/blue]

 

[SQLSister]

Select CASE 
      WHEN (field1)<> 9 THEN FIELD1
      ELSE ' '
END AS IDTYPE1

Questions about posting. See faq183-874

 

[vongrunt]

If field1 is number, this isn't a good example. Two data types - one column.
If field1 is string, this will work because of implicit conversion (9 into '9').

Anyway, how about no if's:

SELECT ISNULL(NULLIF(field1, 9, ' '))

 

[vongrunt]

Dang... typos.

select isnull(nullif(field1, 9), ' ')

 

[PreacherUK]

Von, my code was just a simplified representation of my thinking, not the actual code Thanks all for the input everyone, I think my syntax was just a little squiffy, blame it on my time with VBA