RE: How To Generate The SELECT statement I need

2001-01-18 Thread Stephen Faustino
TED]] Sent: Thursday, January 18, 2001 9:13 AM To: '[EMAIL PROTECTED]' Subject: How To Generate The SELECT statement I need Hi, I need to generate a select statement that has a comparison in it. I have checked the FAQ to no avail. I want to write something like this: SELECT * FROM customers W

RE: How To Generate The SELECT statement I need

2001-01-18 Thread Stephen Faustino
: Thursday, January 18, 2001 9:13 AM To: '[EMAIL PROTECTED]' Subject: How To Generate The SELECT statement I need Hi, I need to generate a select statement that has a comparison in it. I have checked the FAQ to no avail. I want to write something like this: SELECT * FROM customers WHERE

How To Generate The SELECT statement I need

2001-01-18 Thread Craig Atkins
Hi, I need to generate a select statement that has a comparison in it. I have checked the FAQ to no avail. I want to write something like this: SELECT * FROM customers WHERE name =~ 'Jo'   which uses the =~ comparison (used in Perl) to return any records that contain the letters 'Jo', which could