freeflow Established Member โ 15 โ Impact 13 Aug 16, 2008 911 views 3 replies #1 How can I delete all blank spaces before and after all entries in a specific column in a database. Thanks.
How can I delete all blank spaces before and after all entries in a specific column in a database. Thanks.
nasaboy007 VIP Member VIP โ 20 โ Impact 66 Aug 16, 2008 #2 http://www.1keydata.com/sql/sql-trim.html Use the SQL TRIM function.
Kate Domainosaurus RexTop Member VIP โ 20 โ Impact 21,828 Aug 16, 2008 #3 Code: UPDATE [table] SET [field]=TRIM([field])
Peter VIP Member VIP โ 20 โ Impact 209 Aug 16, 2008 #4 If you already have the data in the tables then the following sql command will remove the speaces UPDATE TABLE_NAME SET colum_name = trim(column_name) oops too late sdsinc just posted near enough the same thing.
If you already have the data in the tables then the following sql command will remove the speaces UPDATE TABLE_NAME SET colum_name = trim(column_name) oops too late sdsinc just posted near enough the same thing.