View Single Post
  #2 (permalink)  
Old June 21st, 2003, 09:36 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi Mateen,

What is it you need to do? What exactly is your question?

If you need to query something from a table, follow this SELECT syntax which you can find in the Books Online (BOL). An example:

SELECT Column1, Column2, Column3 FROM TableName WHERE Column1 = aValue

What are you trying to do with TRIM, RTRIM, STR, SUBSTRING, SPACE,STUFF, CHARINDEX?? These are functions you can use in your queries. For their usage, please look in the BOL.

Cheers,

Imar


----------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote