|
I found this select syntax online but not able to make it work. Please help. I have a table that have colName as TEXT column that has special ascii characters from 0 thru 31. I an trying to do a select for this colName that will replace all special characters as '?' What am I doing wrong in this select? select REPLACE(**colName**, SUBSTRING(**colName**, PATINDEX('%[^a-zA-Z0-9 ]%', **colName** collate Latin1_General_BIN), 1), '?') from table WHERE PATINDEX('%[^a-zA-Z0-9 ]%', **colName** collate Latin1_General_BIN) <> 0 |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 25 Mar '13, 17:00
question was seen: 6,314 times
last updated: 27 Mar '13, 12:18
What database software are you using? ... I ask because the 'collate Latin1_General_BIN' syntax is not supported by SQL Anywhere ... so where did you find the syntax online.
Please refer to the SA documentation which you can find at http://dcx.sybase.com - specifically you can find the patindex function here.
We have Adaptive Server Enterprise.
This isn't the forum you're looking for...
Be careful:
The EmpireHANA Strikes Back...