C
Charlie Williams
I have a routine to update my SQL Server database where I
call a stored procedure and pass it the appropriate
parameters. Everything works ok, except that the fields
that I have defined in my DB as varchar are being padded
with whitespace, as if they were char fields. I even
tried calling Trim() on the strings before assigning them
to the value of the parameters in question, but it did not
help.
What am I missing?
Charlie (SQL newbie, in case it wasn't obvious)
call a stored procedure and pass it the appropriate
parameters. Everything works ok, except that the fields
that I have defined in my DB as varchar are being padded
with whitespace, as if they were char fields. I even
tried calling Trim() on the strings before assigning them
to the value of the parameters in question, but it did not
help.
What am I missing?
Charlie (SQL newbie, in case it wasn't obvious)