Problem with Ms-query (text & numeric values)

Hi,

I'm trying to make a query on another file. In the first column I want to extract I have the product code which is sometime a number and sometime in text format. The query gets the one that are numerical and leaves blank for the text ones. I tried to convert the source file to have all in text format and it works within the query. I can't really change the source, is there a way in the sql statement to force all value as text? No problem to add a text character in the query if it would be possible to force it as text...

Product can be like 28 or 28XLS or HP2001...

Any idea ?

Thanks
Eric