[thelist] Numerical Wildcard in SQL
Tab Alleman
talleman at Lumpsum.com
Wed Mar 1 14:04:23 CST 2006
I didn't understand your bottom line description of the problem, but you can use SUBSTRING to get each individual character in a varchar field, and use BETWEEN to test whether it's 0-9.
At least that's what I think you're asking in the first sentence...
> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Rob Smith
> Sent: Wednesday, March 01, 2006 2:38 PM
> To: thelist at lists.evolt.org
> Subject: [thelist] Numerical Wildcard in SQL
>
>
> Hi,
>
> Is there something you can use in the like clause that will match 5
> numerical digits. The closest thing I've come up with so far is where
> field like '_____'. Bottom line, I'm trying to cross the
> customer's zip
> code to our preferred warehouse locations. We have the entire table of
> zip code ranges linked to ware house locations. There's no
> "ID" to link
> the two tables together, so I'm linking a range of values together.
>
> Gracias,
>
>
> Rob Smith
> LexJet
> rob.smith at lexjet.com
> http://www.lexjet.com
> (800)453-9538
> (941)330-1210 Int'l
> (941)330-1220 Fax
> 1680 Fruitville Road, 3rd Floor
> Sarasota, FL 34236
>
> Proud Sponsors of the Professional Digital Imaging
> Association (www.pdia.org)
>
>
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
More information about the thelist
mailing list