What is the best way to query for columns which contain embedded carriage returns?
Printable View
What is the best way to query for columns which contain embedded carriage returns?
Try clause like
WHERE ACSII(substring(XXXX,n1,1)=13 ( or 10)
On 8/3/98 9:28:41 AM, wrote:
> What is the best way to query for columns which contain embedded carriage
> returns?
Thanks Jonathan,
This works excellently if you know the position at which the Carriage return is located. However, I need to scan the database to identify (and subsequently correct) any columns which contain a CR anywhere inside the text. Any more ideas?
On 8/3/98 7:35:19 PM, Jonathan Yang wrote:
>
Try clause like
WHERE ACSII(substring(XXXX,n1,1)=13 ( or
> 10)
On 8/3/98 9:28:41 AM, wrote:
> What is the best way to query
> for columns which contain embedded carriage
> returns?