im trying to find the equivalent of the below oracle code in sql server.But to my knowledge i feel "translate "is not supported by sql server. so please send me the equivalent sql server query for this.
SELECT 'http://ploft.com/ploft?y='||translate(comp,' ','+')||',+'||translate(california,'
','+')||',+'||ca||'+'||pz
INTO :ls_MAP FROM project WHERE portno=:dbno;I believe the REPLACE function is what you are after in SQL Server.|||thank you crowley
how to use 'replace' function to change the characters in a given column.In oracle we can do that (its in above query)|||http://msdn.microsoft.com/library/en-us/tsqlref/ts_ra-rz_76lh.asp?frame=true
replace (query, 'TRANSLATE', 'REPLACE')
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment