Trimming SQL varchar fields

C

Chris Kennedy

Is there any way to trim all the content coming out of a sql server in the
project without either setting ANSI NULL PADDING to off (which Microsoft
don't recommend) or doing the trim for every single field. There must be a
more obvious solution? I tried using the trim function in the stored
procedures' SELECT statement but that made the bound field non-updateable.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Project - need to trim fields 4
adodb.command execute crash 3
trim trailing spaces on data in a text box 3
Invalid SQL Statement Error 4
MS ACCESS query returns empty recordset from odbc linked sql server tables 3
your 2 cents on this form design 3
pass memo field to sql stored procedure parameter 0
CHAR fields and spaces in textbox field 7

Top