I have a db in which I'm performing a search.
I'm using the SQL Statement shown below, which works in VB but not in ASP where it returns no record... Any idea ?

SELECT * FROM Postes WHERE NoEnsemble LIKE 'M*' OR Utilisation LIKE 'M*' OR [Serial No] LIKE 'M*' ORDER BY NoEnsemble

My db contains approximatively 200 data with NoEnsemble = "M99999" where 9 is any number. In vb it returns every records starting with 'M' but no go in asp ? Sort'of confused here !

Any help greatly appreciated !