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!



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net