View Single Post
  #5 (permalink)  
Old 04-10-2008, 08:23 AM
raghu408 raghu408 is offline
Member
 
Join Date: Apr 2008
Posts: 4
raghu408 is on a distinguished road
That would be an option if i just need to do this on this particular string but the way i want is like what ever sql you pass it should parse for such strings that has '||' so that i could convert them to SqlServer acceptable format .

This is a requirement because || is not allowed in sql server instead we need to use CONCAT

example a||b||c in oracle is equivalent to CONCAT(a,b,c) in SqlServer
Reply With Quote