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.
Custom Apps, Inc.