Sql problem - please help

[eL_NiNo]

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 !

[MarcelB]

Hi,

You might wanna try this:

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


Good luck,
Marcel

[eL_NiNo]

Great ! It worked !
Thanks a lot !