Extra Spaces in the database

[MrColdFusion]

After inserting into a char field I have spaces padding out the field... How can I turn this off...

When I do a query to see if test = field and the field contains test but it is a char(10) then it will not be true.

HELLLLPPPPP!!! X-)

Thanks,
Mr.ColdFusion [sig][/sig]

 

[crystalized]

can you use a varchar field? [sig]<p>Crystal<br><a href=mailto:crystals@genesis.sk.ca>crystals@genesis.sk.ca</a><br><a href= > </a><br>--------------------------------------------------<br>
Experience is one thing you can't get for nothing.<br>
-Oscar Wilde<br>
[/sig]

 

[TomSark]

You can use the rtrim and ltrim functions in code to do the test. Or, to turn it off, use a varchar(10) data type. varchar won't of course, give you padding.

To trim for a code test, do this:

If RTrim(LTrim(column)) = @field_i_am_testing
Begin
-- whatever...
End

Tom [sig][/sig]