Home
MS SQL Trim On Insert
INSERT INTO xxxTable(emailf) VALUES (TRIM( ' ren@techsolus.co.uk '))
This will simply remove the white spaces around the email address before inserting into the database table. This can be altered so google the SQL TRIM function. It's possible to remove certain characters etc etc.
Reader's Comments
Name
Comment
Add a RELEVANT link (not required)
Upload an image (not required)
Uploading...
Home