Contains in asp sql statement

[4954]

how to do this in asp sql ?

sele * from tablex where field1 contains field2 ?

eg. field1 = 'abc xyz 123'

field2 = 'yz'



thanks.

 

[ChrisHirst]

SELECT * FROM table WHERE INSTR(column1, column2);

should work (depending on the SQL version


Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[4954]

how if ADO connection to dbf file ? seem not working

any other simply solutions..