Sure you can but it'll not be optimizable. Also if columns are varchar you may not even need to trim them.
>SQLSERVER 2000 or 2005.
>
>Is it possible to do something like:
>
>
>
>mvalue = '100'+'SO'+'MAIN'+'ST'
>SELECT * FROM mysqltable
where alltrim(number)+alltrim(st_prefix)+alltrim(street)+alltrim(st_suffix) = myvalue
>
>?
--sb--