On Sunday 21 October 2007 2:32 pm, Bob Pawley wrote: > I have a column with data structured as follows. > > 32TT - 0002 > 32LT- 0004 > 32PT-0005 > > Is there a way of selecting all of the rows containing LT in that column?? > > > I have attempted variations of ' *LT* ' with out success. > > Bob Pawley
select col where col LIKE '%LT%'; See also: http://www.postgresql.org/docs/8.2/interactive/functions-matching.html#FUNCTIONS-LIKE -- Adrian Klaver [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
