I think, that it sometimes could be useful as secondary protection: a feature (perhaps another "pragma"?), which will cause stripping the spaces from beginning and end of every inserted string. But perhaps even not just only as "secondary"?
Yes, usually it's done at application level; I was wondering lately, why not "from the other end"? Seems to not be that difficult to implement. In fact, almost always we want to insert into database the strings with no spaces at beginning, neither at the end - so perhaps adding a possibility to set such behaviour (using "pragma") as "default" seems to be logical? What do you think? -- pozdrawiam / regards Zbigniew Baniewski ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------