Topic: Ltrim in a cycle
All greetings. Prompt please as it is possible to erase quickly all gaps at all table
There is a table guest, in it a column comment, in it it is necessary to erase leading blanks
SELECT *, LTRIM (comment) FROM guest where comment like ' % OF %'
The given request I receive an array, and here is how these values without a gap again to write down in a DB? At each line unique id.
I in SQL am not strong, on mind comes to create only the table new, there all to interpose, erase in existing and reversely to interpose from the temporary table. Can eat easier a variant?