blogs.conchango.com

Browse by Tags

• LTRIM
• PL/SQL
• RTRIM
• TRIM
• T-SQL
• White space

• SQL: Using the Trim function to remove white space from a field

  Today I was looking at a table with an apparantly empty column and discovered that the field is actually populated with blank spaces - Fortunately this field is of no interest to me and I noticed it purely by chance when I pasted an extract of the dat Read More... Posted 14 August 2007 16:19 by James.Pipe | 12 Comments Filed under: PL/SQL, SQL, T-SQL, Formatting code, LTRIM, TRIM, RTRIM, White space

• Automatically format your SQL statements

  A colleague forwarded me this link today, which I thought would be beneficial to anyone who has to write a lot of SQL statements. The tool will automatically format the statements to 'beautify' them, so no more excuses for 'ugly' code! Read More... Posted 09 August 2007 19:26 by James.Pipe | 0 Comments Filed under: PL/SQL, SQL, T-SQL, Formatting code