Database Discussion - SQL Statement Help

Print Page | Close Window

SQL Statement Help

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7015
Printed Date: 30 March 2026 at 3:35pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL Statement Help

Posted By: fark
Subject: SQL Statement Help
Date Posted: 05 November 2003 at 8:21am

I am writing a zone lookup program. One of my fields provides me with a summary of the first 3 digits of the destination zip codes (like this 048-089). Can I use my SQL Statement to search for the matching zip code range?

if I am searching for the zip code 050** how do I write my SQL Statement so that it find the field 048-089?

Thanks

Replies:

Posted By: Mart
Date Posted: 05 November 2003 at 10:47am

SELECT * FROM table WHERE zipcode LIKE'050%';

I think, if not try http://www.w3schools.com/sql - www.w3schools.com/sql

Mart.

Posted By: Mart
Date Posted: 05 November 2003 at 10:48am

http://www.w3schools.com/sql/sql_where.asp - http://www.w3schools.com/sql/sql_where.asp

Posted By: fark
Date Posted: 06 November 2003 at 7:33am

Thanks you've been a great help. I appreciate it!