>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
>
>?
Does each field in SQL Server have predefined length? If yes, can you pad each value with exact number of spaces?
If it's not broken, fix it until it is.
My Blog 
