LIKE operator

Article View: bit.databases.mssql-l

Article #66

Back to bit.databases.mssql-l Previous Next

#66

From: Jacob
Date: Thu, 23 Mar 2000 00:00

11 lines
1656 bytes

Hi Everyone

I have a SQL Server 7 table who's primary key is a column of 'int' data
type, I use int because I want it to be an Identity field, but I would like
to create queries that use the LIKE operator to search for string patterns,
but I keep getting errors because the LIKE operator works only with string
data types. If anyone knows a workaround for this I would appreciate your
help.

Thanks
Jacob

Technical Details

Message-ID: <8bd80o$7sri$1@node17.cwnet.frontiernet.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 104de1,85bb05223c1e0dda,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: ff490,85bb05223c1e0dda,start
X-Google-Attributes: gidff490,public
X-Google-Thread: 11301e,85bb05223c1e0dda,start
X-Google-Attributes: gid11301e,public
X-Google-Thread: 107d2f,85bb05223c1e0dda,start
X-Google-Attributes: gid107d2f,public
X-Google-Thread: f6611,85bb05223c1e0dda,start
X-Google-Attributes: gidf6611,public
X-Google-Thread: 104e26,85bb05223c1e0dda,start
X-Google-Attributes: gid104e26,public
From: "Jacob" <jsilberstein@eazall.com>
Subject: LIKE operator
Date: 2000/03/23
Message-ID: <8bd80o$7sri$1@node17.cwnet.frontiernet.net>
X-Deja-AN: 601301268
Sender: UNKNOWN@www.eazall.com
X-Trace: node17.cwnet.frontiernet.net 953819992 258930 12.3.227.2 (23 Mar 2000 13:59:52 GMT)
Organization: Frontier GlobalCenter Inc.
X-MSMail-Priority: Normal
X-Priority: 3
NNTP-Posting-Date: 23 Mar 2000 13:59:52 GMT
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Newsgroups: bit.databases.mssql-l,comp.databases.ms-sqlserver,cz.comp.microsoft.sql,git.sql-help,microsoft.public.sqlserver,microsoft.public.sqlserver.programming
X-Complaints-To: abuse@frontiernet.net