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. LIKE '%LT%' perhaps? Or ~ 'LT' (unanchored regex) -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4" "El número de instalaciones de UNIX se ha elevado a 10, y se espera que este número aumente" (UPM, 1972) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly