-
any idea how to search for a " in a varchar column and get rid of it?
-
select replace('123"456', '"', '') from dual
-
replace(column1,'"') (double quote inside single quotes)
This will eliminate all " inside the string
-
I personally prefer this method
replace(column1,Chr(34))
Ie. Chr(34) stands for "
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|