Putting inverted commas around the sub strings in one string
586922Dec 10 2008 — edited Dec 10 2008Hi Guys,
I am having one parameter in my report which will give a list of values, all values will be comma seperated, I have to put inverted commas around all the strings in that value which I got from that parameter, means
if parameter value is 64671, 64673, 6478
I have to convert it to '64671', '64673', '6478', becasue this is varchar in table and i have to use this value in query like .....
where we.wip_entity_name in ('64671', '64673', '6478')
.......................
Please let me know if there is any string functions in SQL which can do this.
Thanks....