Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Where "DOES NOT BEGIN WITH"

Posted on 2008-06-23
3
Medium Priority
?
2,619 Views
Last Modified: 2008-06-23
I am having trouble figuring out how to convert this psuedo code into real SQL

where item number does not being with '*'

Any ideas?
0
Comment
Question by:r270ba
  • 2
3 Comments
 
LVL 40

Accepted Solution

by:
Richard Quadling earned 2000 total points
ID: 21850512
where column not like '*%'
0
 

Author Comment

by:r270ba
ID: 21850523
I love this place!  Thaks for your help.
0
 
LVL 40

Expert Comment

by:Richard Quadling
ID: 21851026
GTH - Glad To Help
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question