At 05:27 19/09/00 -0500, John McKown wrote:
>Assuming that the name of the table is "test1" and the variable containing
>the values of interest is name "values", then:
>
>SELECT * FROM test1 WHERE values LIKE 'JYR%';
or
select * from test1 where values ~ '^JYR';
or for case insensitive:
select * from test1 where values ~* '^JYR';
Steve
--
thorNET - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax: 01454 854412
http://www.thornet.co.uk