Re: HoH keys with trailing white spaces ????

I've never worked with MSSQL, but other database engines (e.g. MySQL) provide a function called "trim", which returns the value of a given string with leading and trailing whitespace removed. So if your existing SQL statement is something like this to select three string fields:

 select foo, bar, baz from some_table
[download]

you could phrase it like this, assuming the MSSQL provides the "trim" function:

 select trim(foo), trim(bar), trim(baz) from some_table
[download]

Comment on Re: HoH keys with trailing white spaces ???? Select or Download Code

Replies are listed 'Best First'.
Re^2: HoH keys with trailing white spaces ???? by 3dbc (Monk) on Dec 14, 2011 at 01:49 UTC
Another good idea, less perl centric, but effective nonetheless, however for mssql there's only ltrim and rtrim and in this case I think it would be rtrim, which I happen to use a lot with this particular database and should've thought of that strait away. Regardless, I'm happy I learned about the chopblanks setting, albeit I still think that should be the default...	[reply]