Eliminating Spaces in a Query

[snoopy92211]

Hello.

I have a query, in which i'm trying to select a company number that has the value of 'x'. But since the file specs for this particular field has a text value of 20. I tried using trim for this query, to pick out the spaces, but it isn't working. Help!!!

Snoopy92211

This is my query. It's not working!

SELECT *
FROM tblsnoopy
WHERE (((trim([blahblah])) In ('123')));

(blahblah is a field in tblsnoopy with a length of 20 but the value is usually only three numbers, as show in this example)
Thanks a lot.

 

[KornGeek]

Instead of "In", should you be using "="?

SELECT *
FROM tblsnoopy
WHERE (((trim([blahblah])) [red]=[/red] ('123')));