<div>
Try something like this:<br />
PATINDEX('%[^0-9][^A-Z][^a<wbr />-z]%', textfield) &gt;&nbsp;0<br />
<br />
To give you non-alpha-numeric characters.<br />
<br />
Or to give you non-printable characters, something like:<br />
PATINDEX('%[^ - Ç]%', textfield) &gt;&nbsp;0<br />

</div>


Try something like this:
PATINDEX('%[^0-9][^A-Z][^a-z]%', textfield) > 0

To give you non-alpha-numeric characters.

Or to give you non-printable characters, something like:
PATINDEX('%[^ - Ç]%', textfield) > 0


<div>
ACPerkins,<br />
<br />
Thanks for your quick response. Is the line<br />
PATINDEX('%[^0-9][^A-Z][^a<wbr />-z]%', textfield) &gt;&nbsp;0<br />
meant to look for anything that is not 0-9 A-Z and a-z ?<br />
<br />
ejr19592004<br />

</div>


ACPerkins,

Thanks for your quick response. Is the line
PATINDEX('%[^0-9][^A-Z][^a-z]%', textfield) > 0
meant to look for anything that is not 0-9 A-Z and a-z ?

ejr19592004


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a number of columns in my dataset one/or more of which I believe might have an embedded special character such as a CR or LF. I have tried using the following in my query: <br />
<br />
patindex('%' + char(13) + '%' , texfield) &gt;&nbsp;0 to no avail. I have also tried charindex with the same result. <br />
<br />
I know that the special character is there because when I export the data out to text somewhere along the way the records gets truncated into two. <br />
<br />
I would like to be able to locate this special character and strip it out. Any suggestions. <br />
<br />
My next step is to write a VB program to go through the dataset. <br />
<br />
Thanks<br />
Eddie
</div>
</div>


Hello,

I have a number of columns in my dataset one/or more of which I believe might have an embedded special character such as a CR or LF. I have tried using the following in my query: 

patindex('%' + char(13) + '%' , texfield) > 0 to no avail. I have also tried charindex with the same result. 

I know that the special character is there because when I export the data out to text somewhere along the way the records gets truncated into two. 

I would like to be able to locate this special character and strip it out. Any suggestions. 

My next step is to write a VB program to go through the dataset. 

Thanks
Eddie

Selecting special characters

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.