Select question

cartjohn · #1 (**permalink**) 01-19-05, 09:59

I am trying to select only the records from a table based on the existence of a character in one of the positions within a particular field. The field type is varchar(19). Can anyone help me with this problem.

Thanks in Advance
John C

Marcus_A · #2 (**permalink**) 01-19-05, 10:07

Use the substring function (substr). See the SQL Reference Vol 1.

nidm · #3 (**permalink**) 01-19-05, 13:00

SELECT * from t where LOCATE(your_character, your_field) = your_position

Quote:

Originally Posted by cartjohn

I am trying to select only the records from a table based on the existence of a character in one of the positions within a particular field. The field type is varchar(19). Can anyone help me with this problem.

Thanks in Advance
John C

Internet Services

Web Development

Digital Marketing

Consumer Tech