SELECT query with TRIM and LIKE

2002-02-13 Thread Victoria Reznichenko
Tshering, Wednesday, February 06, 2002, 7:29:11 AM, you wrote: TN> Dear list, TN> I have a telephone database which has "Name" as one of the fields/columns. TN> This field contains single name e.g Robert, double names e.g Robert TN> Downing and more than double names. I want to make a SELECT

Re: SELECT query with TRIM and LIKE

2002-02-12 Thread Tshering Norbu
Thanks Nathan, I think I will go with "SELECT * FROM table_name WHERE Name LIKE > '%$name%'"; NOBBY - Original Message - From: Nathan Bank <[EMAIL PROTECTED]> To: Tshering Norbu <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 12:25 PM Subject:

SELECT query with TRIM and LIKE

2002-02-11 Thread Tshering Norbu
Dear list, I have a telephone database which has "Name" as one of the fields/columns. This field contains single name e.g Robert, double names e.g Robert Downing and more than double names. I want to make a SELECT query using a form whose input name is "Name" i.e '$Name' against the "Name" fie

SELECT query with TRIM and LIKE

2002-02-08 Thread Victoria Reznichenko
Tshering, Wednesday, February 06, 2002, 7:29:11 AM, you wrote: TN> Dear list, TN> I have a telephone database which has "Name" as one of the fields/columns. TN> This field contains single name e.g Robert, double names e.g Robert TN> Downing and more than double names. I want to make a SELECT

Re: SELECT query with TRIM and LIKE

2002-02-08 Thread Tshering Norbu
Thanks Nathan, I think I will go with "SELECT * FROM table_name WHERE Name LIKE > '%$name%'"; NOBBY - Original Message - From: Nathan Bank <[EMAIL PROTECTED]> To: Tshering Norbu <[EMAIL PROTECTED]> Sent: Friday, February 08, 2002 12:25 PM Subject:

SELECT query with TRIM and LIKE

2002-02-07 Thread Tshering Norbu
Dear list, I have a telephone database which has "Name" as one of the fields/columns. This field contains single name e.g Robert, double names e.g Robert Downing and more than double names. I want to make a SELECT query using a form whose input name is "Name" i.e '$Name' against the "Name" fie