--- Newbie --- Removing character in a field in SQL

[lmcate2]

Create a record in access 97 and saving it via SQL server the server is adding a chr(0)to the end of a text field.

for Example Milk = charcters and read it back fomr SQL SERVER the lenght is 5 character which one is hidden.

Does anyone knows how to remove it.

 

[checkai]

replace(fieldname,char(0),'')

"...your mom goes to college..."

 

[jbenson001]

How about RTrim(fieldname)