Locate Upper and/or lower case data string

• rons-605185

  SSCommitted

  Points: 1618

  More actions

  April 15, 2009 at 2:00 pm

  #131285

  SQL newbie using MS SQL 2005.

  Have customer order table with customer order numbers that are prefixed with "CQS" followed by a 7 digit number.

  Example: CQS0002537.

  Somehow users managed to input some of the customer order numbers as lower case "cqs0002536" instead of the correct upper case CSSxxxxxx.

  Question: what is the syntax of a sql script/query to search the co_num column in the customers table to show just

  the data that is "cqs%" but not return "CQS%".

  Would also like to know how to do the same for the inverse (show only the upper case "CQS" but not the

  lower case "cqs").

  I tried the Upper and Lower functions but it showed all results in either upper/lower case - it did not show the data as it really exists.

  Thanks.

  Ron Siem

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  April 15, 2009 at 2:15 pm

  #978390

  Duplicate post: http://www.sqlservercentral.com/Forums/Topic697897-338-1.aspx