Wednesday, March 21, 2012

replace command

can the command replace use variables ie
replace(@.Name,'.com','.com;')
im getting an error with this and i was just wondering if it was just me
JimOriginally posted by JDionne
can the command replace use variables ie

replace(@.Name,'.com','.com;')

im getting an error with this and i was just wondering if it was just me
Jim

figured it out i needed a select in my code
select replace(@.Name,'.com','.com;')
Jim

No comments:

Post a Comment