How to select only capital word?

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  May 29, 2014 at 1:46 pm

  #308571

  In company there are two version of app. New one save order status as "Ordered" the old save as "ORDERED". In order to find out who use old version, how to code in where clause like below?

  select userid from order where status = 'ORDERED' (only capital)

  (Above code will list all)

• SQL is delicious

  Ten Centuries

  Points: 1007

  More actions

  May 29, 2014 at 1:50 pm

  #1717561

  Try this:

  select userid from order

  WHERE status = UPPER(status) COLLATE SQL_Latin1_General_CP1_CS_AS