sql server programming: Trimming Padding spaces -- sql server programming

Trimming Padding spaces

Designer
3/20/2005 11:35:03 PM

sql server programming: I have a table with 17 fields out of which 8 are of Char datatype. While
retrieving the records from this table, found that all the fields with char
datatypes are filled with padding zeros. Because of this reason, my
application doesnt allow me to edit any of this field values.

Kindly provide me a solution for the above problem.

RE: Trimming Padding spaces

Aleksandar Grbic
3/21/2005 12:17:04 AM

try convert char column to varchar

[quoted text, click to view]

Re: Trimming Padding spaces

Armando Prato
3/21/2005 10:51:26 AM

Could you provide an example? Your subject says "trimming padding spaces"
but your text indicates it's trailing zeros.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.