SQL search problem

[Guest]

I am designing a lookup table. In the table are columns called id, countryprefix, country and rate. If i have a phone number i want to search the countryprefix column and have the search return the country and the rate, how do i go about doing this?

[Newsgroup_User]

Parse out the country prefix from the number (don't know how/what the
input looks like, so it is a vague answer there)

With that:
SELECT country, rate FROM table WHERE countryprefix = "parsedInfo"

Paul Davis
http://www.kaosweaver.com/
Visit us for dozens of useful Dreamweaver Extensions.

http://www.communitymx.com/
Partner at Community MX - Extend your knowledge

kezzab25 wrote:
> I am designing a lookup table. In the table are columns called id,
> countryprefix, country and rate. If i have a phone number i want to search the
> countryprefix column and have the search return the country and the rate, how
> do i go about doing this?
>