novaBBS - comp.sys.tandem - SQLCI Checking for special characters in Alphanumeric field

SQLCI Checking for special characters in Alphanumeric field

<421bcdba-a786-40ef-aad1-90b70b7e237an@googlegroups.com>

https://www.novabbs.com/computers/article-flat.php?id=274&group=comp.sys.tandem#274

X-Received: by 2002:a05:620a:752:: with SMTP id i18mr14648559qki.453.1636746888995;
Fri, 12 Nov 2021 11:54:48 -0800 (PST)
X-Received: by 2002:a25:2157:: with SMTP id h84mr20050779ybh.425.1636746888810;
Fri, 12 Nov 2021 11:54:48 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!news.uzoreto.com!peer01.ams4!peer.am4.highwinds-media.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Fri, 12 Nov 2021 11:54:48 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=50.204.224.200; posting-account=0NHiHgoAAAC-mY8P0yk1bd3zDKN8t6jB
NNTP-Posting-Host: 50.204.224.200
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <421bcdba-a786-40ef-aad1-90b70b7e237an@googlegroups.com>
Subject: SQLCI Checking for special characters in Alphanumeric field
From: abolk...@gmail.com (Adam Kamal)
Injection-Date: Fri, 12 Nov 2021 19:54:48 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1460

by: Adam Kamal - Fri, 12 Nov 2021 19:54 UTC

A question from Enscribe guy to all SQL experts out there.

I have an address data field and was trying to write a SQL query to find records that have special characters in this address field.

Special characters may include backspace , newline (linefeed), carriage return or a tab characters.

Is there a SQL function can be used. I looked into STRING but it does not seem it will provide the desired outcome. Thanks in advance for your time.

Re: SQLCI Checking for special characters in Alphanumeric field

<f938efce-8466-4639-a9f6-68f6ae177714n@googlegroups.com>

copy mid

https://www.novabbs.com/computers/article-flat.php?id=275&group=comp.sys.tandem#275

copy link Newsgroups: comp.sys.tandem

X-Received: by 2002:a05:622a:24a:: with SMTP id c10mr10445616qtx.209.1636856659431;
Sat, 13 Nov 2021 18:24:19 -0800 (PST)
X-Received: by 2002:a25:2c97:: with SMTP id s145mr30038662ybs.408.1636856659233;
Sat, 13 Nov 2021 18:24:19 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.tandem
Date: Sat, 13 Nov 2021 18:24:18 -0800 (PST)
In-Reply-To: <421bcdba-a786-40ef-aad1-90b70b7e237an@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2607:fea8:3ddf:f2b0:1d92:5b76:a185:3f41;
posting-account=6VebZwoAAAAgrpUtsowyjrKRLNlqxnXo
NNTP-Posting-Host: 2607:fea8:3ddf:f2b0:1d92:5b76:a185:3f41
References: <421bcdba-a786-40ef-aad1-90b70b7e237an@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <f938efce-8466-4639-a9f6-68f6ae177714n@googlegroups.com>
Subject: Re: SQLCI Checking for special characters in Alphanumeric field
From: rsbec...@nexbridge.com (Randall)
Injection-Date: Sun, 14 Nov 2021 02:24:19 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 10

by: Randall - Sun, 14 Nov 2021 02:24 UTC

On Friday, November 12, 2021 at 2:54:49 p.m. UTC-5, abol...@gmail.com wrote:
> A question from Enscribe guy to all SQL experts out there.
>
> I have an address data field and was trying to write a SQL query to find records that have special characters in this address field.
>
> Special characters may include backspace , newline (linefeed), carriage return or a tab characters.
>
> Is there a SQL function can be used. I looked into STRING but it does not seem it will provide the desired outcome. Thanks in advance for your time.

I'm not sure how to inject a special character in SQLCI, but a simple C program to do this would set a host variable to the ASCII character you want and then use a SELECT ... WHERE POSITION(:charhv in field) > 0 or some such statement might work for you.
-Randall

An elephant is a mouse with an operating system.

computers / comp.sys.tandem / SQLCI Checking for special characters in Alphanumeric field

Subject	Author
SQLCI Checking for special characters in Alphanumeric field	Adam Kamal
Re: SQLCI Checking for special characters in Alphanumeric field	Randall