A SELECT question

• Clemens

  SSC Rookie

  Points: 28

  More actions

  July 23, 2003 at 1:34 am

  #82919

  I have a SELECT question:

  SUMMARY TABLE LAYOUT:

  ID char(16)

  ATTR varchar(6)

  LANG char(2)

  SOMETEXT ntext

  LANG is a language id; this can be specific (like EN) or neutral (like -).

  I want to select certain attr's given an ID; when the passed variable matches the LANG

  I want that row returned, otherwise the row with the LANG='-'... How do I do that?

• mccork

  SSC-Insane

  Points: 22288

  More actions

  July 23, 2003 at 3:02 am

  #466536

  Maybe something like...

  
  
  SELECT TOP 1 *
  
      FROM MyTable
  
      WHERE ID = @ID
  
      ORDER BY CASE WHEN LANG = '-' THEN 'b' ELSE 'a' END 

  
  Cheers,
  - Mark

• DavidT

  SSCommitted

  Points: 1727

  More actions

  July 23, 2003 at 5:06 am

  #466556

  select *

  from MyTable

  where (@Lang = Lang and Id = @Id)

  or (Lang = '-')