Hi all,

Please send the practical example of sql server function
ie.
trim, replace, str

table name is project
table fields are
projectid
project description
projectname
imagename

regards.

Mateen Martin
[email protected]

The LTRIM function trims leading spaces, the RTRIM function trims trailing spaces. Combine them to trim from both sides, eg SELECT LTRIM(RTRIM(projectname) As TrimProjName...

The REPLACE function replaces all occurances of one string with another, e.g:
SELECT REPLACE(projectdescription,'x','y') as YforXName... replaces all occurances of the letter 'x' with the letter 'y' in the projectdescription.

Not sure what you want by 'str' - if you are looking for the VB equivalent, converting a numeric to it's string equivalent, you can use the STR function to convert a floating point number to a character string, but better is perhaps the CAST function to convert any numeric datatype to varchar.


Jeff Mason
Custom Apps, Inc.
www.custom-apps.com