replace

Am pretty new to SQL Server..
Am exploring the existing SPs..
I would like to know what the command replace does?
Also what does the convert do??
TIA,
Nishasee REPLACE (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp) and CAST and CONVERT (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp) in the microsoft sql/server web site

rudy
http://rudy.ca/|||also, the Books OnLine shipped with SQL Server is an excelent source of information.

Half or more of all questions asked on this board could have been asnwered by reading this document first.