|
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 |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
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,609 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...