View Single Post
  #3 (permalink)  
Old June 23rd, 2003, 07:03 PM
David Cameron David Cameron is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Sydney, NSW, Australia.
Posts: 215
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Mateen,

You have posted a lot of messages asking questions that would be quickly answered by examining the avilable documentation. It would be better if you checked the documentation before resorting the list.

In this case the documentation SQL Books Online (free to download if you don't already have it). There are very good examples of SELECT and TRIM, RTRIM, STR, SUBSTRING, SPACE, STUFF, CHARINDEX there.

regards
David Cameron
Reply With Quote