-
Finding embedded carriage returns
What is the best way to query for columns which contain embedded carriage returns?
-
Finding embedded carriage returns (reply)
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?
-
Finding embedded carriage returns (reply)
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|