zumpner
01-21-2003, 07:46 PM
i'm very new to MS MQL and somewhat new to SQL in general. Can somebody tell me why the following query gives me nothing in return (not null, not undefined, just blank)?
SELECT RTRIM(navNumber), RTRIM(title) From pages
It works fine when i take off the RTRIM (except for the fact there there are trailing spaces). I did not have to worry about this in access but ms sql presents this problem.
Thanks in advance,
Ryan
SELECT RTRIM(navNumber), RTRIM(title) From pages
It works fine when i take off the RTRIM (except for the fact there there are trailing spaces). I did not have to worry about this in access but ms sql presents this problem.
Thanks in advance,
Ryan