Re: LIKE operator

Article View: bit.databases.mssql-l

Article #67

Back to bit.databases.mssql-l Previous Next

#67

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

24 lines
1617 bytes

Jacob,

What sort of string patterns are you searching for?

You can use the STR function or the CONVERT/CAST functions to transform an int
into a char inside your query.

Jacob <jsilberstein@eazall.com> wrote in message
news:8bd80o$7sri$1@node17.cwnet.frontiernet.net...
> 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: <38da259b_3@news3.prserv.net>

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

References: <8bd80o$7sri$1@node17.cwnet.frontiernet.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff490,85bb05223c1e0dda
X-Google-Attributes: gidff490,public
X-Google-Thread: 104de1,85bb05223c1e0dda
X-Google-Attributes: gid104de1,public
X-Google-Thread: f6611,85bb05223c1e0dda
X-Google-Attributes: gidf6611,public
From: "BPMargolin" <bpmargo@attglobal.net>
Subject: Re: LIKE operator
Date: 2000/03/23
Message-ID: <38da259b_3@news3.prserv.net>
X-Deja-AN: 601302665
References: <8bd80o$7sri$1@node17.cwnet.frontiernet.net>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Complaints-To: abuse@prserv.net
X-Trace: 23 Mar 2000 14:09:31 GMT, 129.37.18.87
Organization: Global Network Services - Remote Access Mail & News Services
X-MSMail-Priority: Normal
Reply-To: "BPMargolin" <bpmargo@attglobal.net>
Newsgroups: bit.databases.mssql-l,comp.databases.ms-sqlserver,cz.comp.microsoft.sql

Reply to Parent Message