I'm trying to figure out how to convert an INT so that I can add it to another string in a statement like
SELECT '<a href="http://links.10026.com/?link=http://mydomain.com/' + [IntValue] + '">' + [LinkName]
Where [IntValue] is an INT field containing a folder number. I tried:
TO_CHAR([IntValue, '999')
but it didn't work. And I tried to find a TO_STRING function, but had no luck.
Any advice to someone who is savy, but new to SQL Queries?
SELECT '<a href="http://links.10026.com/?link=http://mydomain.com/' + STR([IntValue]) + '">' + [LinkName]
HTH
regards
Thanks a bunch!
No comments:
Post a Comment