What are the challenges you face when working across database platforms? Take the survey
Options

Snippet Suggestion for Trim

malcolm.daughtreemalcolm.daughtree Posts: 16
edited September 17, 2007 5:58PM in SQL Prompt Previous Versions
SQL2000 doesn't have a trim function :? to remove trailing AND leading spaces, at least this will lessen the occurance of RSI

I use 'tr' as the snippet entry

Ltrim(RTrim($CURSOR$))

Hope that helps someone !!
CodeOn ;-)

Comments

Sign In or Register to comment.