Query

• Reddy-360666

  SSC Veteran

  Points: 256

  More actions

  October 19, 2006 at 11:07 am

  #114741

  I have a result set with 2 char where in all records are either ST,SV,SU......

  when using an IF condition how can I find the odd one from that result set. Odd one in the sense there shud be no other record other than ST,SU,SV, If so I have to kick an error mesg.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  October 19, 2006 at 11:09 am

  #666870

  Select Id, Col2, YourCol from dbo.YourTable where YourCol NOT IN ('ST', 'SV', 'SU') order by ??

   

• CK Bhatia

  Say Hey Kid

  Points: 679

  More actions

  October 19, 2006 at 3:07 pm

  #666939

  If you are just interested in raising an error if one of the other "types" exists then you can use the following

  if exists (select top 1 1 from dbo.YourTable where YourCol NOT IN ('ST', 'SV', 'SU') )

  begin

   raiserror ....

   any other error handling

   return

  end

   

   

  ---

  I feel the need - the need for speed

  CK Bhatia