Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dupati1
Posting Yak Master
123 Posts |
 Posted - 2005-11-02 : 13:11:44
|
| Guys,I have a table with a text field called ResumeTextLets say simplified table looks like below...EmpID | ResumeText__________________1 | blahblahblah2 |sdklfjndsfdswhat i am trying to do is to find only those records that have a non ascii characters in the ResumeText...for example...SELECT EmpID, ResumeText FROM mytableWHERE PATINDEX('% %',ResumeText)>0gives me all the records that contain a single space...how to i write something similar for the filtering all the records that containing nonascii character...do i need to write multiple Patindexes to cover all the nonascii characters...Any Suggestions |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-02 : 13:14:51
|
| Something like http://www.mindsdoor.net/SQLTsql/FindNonAlphaCharacters.htmlsopatindex('%[^a-zA-Z0-9 ]%',fld) <> 0i.e. everything with a char not in a-zA-Z0-9==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
dupati1
Posting Yak Master
123 Posts |
Posted - 2005-11-02 : 13:27:30
|
| yep..thats exactly what i was looking for... |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
non ascill characters + text field