Is it possible to run a query to delete a preceding blank space? For instance MyData is incorrect as MyData
More details in PM
More details in PM
Yes, you can use a query to do that. TRIM() will remove preceding and trailing spaces, so something like:
UPDATE table SET ColumnName = TRIM(ColumnName)
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.