473,322 Members | 1,480 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

simple SQL question

atsukoarai86
I've got a small quandary here. Nothing big, just a little question.

I'm experimenting with SQL with a small database I'm similarly experimenting with, and I'm trying to write a select statement with the like clause and wild card patterns and all that.

Anyway, the code goes a' like this:

Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM tblContractors
  2. WHERE strLastName like 's*'
  3. ORDER BY strLastName asc; 
only when I click the execute button, it gives me a dialogue box that says "Enter Parameter Value" for "strLastName" ...

I'm doing this in Microsoft Access. I'm sure someone can explain this. Thank you in advance.
Sep 18 '08 #1
2 1013
docdiesel
297 Expert 100+
Hi,

in SQL the wildcard parameter is the percent sign '%', so you should use a condition like "WHERE strLastName like 's%' ". But be aware that this comparison is case sensitive, means "Somename" won't match.

Furthermore statements like this use a lot of I/O and CPU because the SQL engine has to read and compare the value of each row. If you've got to compare to the first letter oftenly, you'd better add a separate column "FIRST_LETTER char(1)" and place an index on that.

Regards


Doc Diesel
Sep 19 '08 #2
Hi,

in SQL the wildcard parameter is the percent sign '%', so you should use a condition like "WHERE strLastName like 's%' ". But be aware that this comparison is case sensitive, means "Somename" won't match.

Furthermore statements like this use a lot of I/O and CPU because the SQL engine has to read and compare the value of each row. If you've got to compare to the first letter oftenly, you'd better add a separate column "FIRST_LETTER char(1)" and place an index on that.

Regards


Doc Diesel
I know in Oracle SQL the Wildcard symbol is %, but in Microsoft Access, the wild card is asterisk *... Using % in MS Access 2003 didn't work out very well... I tried:

Expand|Select|Wrap|Line Numbers
  1. SELECT strLastName, dteHIreDate
  2. FROM tblContractors
  3. WHERE strLastName like '%sher%'
  4. ORDER BY dteHireDate;
And it didn't return anything, even though I know for a fact in the strLastName column there's a value that matches that pattern, "Sherman". When I change the % symbols in the select statement to * it works fine.

I don't know what I did to it, but for some reason the query works now. <.< I've tried to reproduce the problem, but I can't. But it was asking me for a parameter value, and I just didn't know what that meant...I guess what that meant was "you typed something, somewhere in wrong" lol... >_<

Anyway thank you for your input. :)
Sep 19 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Patchwork | last post by:
Hi Everyone, Please take a look at the following (simple and fun) program: //////////////////////////////////////////////////////////////////////////// ///////////// // Monster Munch, example...
1
by: Proteus | last post by:
Any help appreciated on a small perl project I need to write for educator/teaching purposes. I have not programmed perl for some time, need to get up to speed, maybe some kind souls hrere will help...
2
by: Raskolnikow | last post by:
Hi! I have a very simple problem with itoa() or the localtime(...). Sorry, if it is too simple, I don't have a proper example. Please have a look at the comments. struct tm *systime; time_t...
3
by: Peter | last post by:
Hello Thanks for reviewing my question. I would like to know how can I programmatically select a node Thanks in Advanc Peter
7
by: abcd | last post by:
I am trying to set up client machine and investigatging which .net components are missing to run aspx page. I have a simple aspx page which just has "hello world" printed.... When I request...
4
by: dba_222 | last post by:
Dear Experts, Ok, I hate to ask such a seemingly dumb question, but I've already spent far too much time on this. More that I would care to admit. In Sql server, how do I simply change a...
14
by: Giancarlo Berenz | last post by:
Hi: Recently i write this code: class Simple { private: int value; public: int GiveMeARandom(void);
30
by: galiorenye | last post by:
Hi, Given this code: A** ppA = new A*; A *pA = NULL; for(int i = 0; i < 10; ++i) { pA = ppA; //do something with pA
10
by: Phillip Taylor | last post by:
Hi guys, I'm looking to develop a simple web service in VB.NET but I'm having some trivial issues. In Visual Studio I create a web services project and change the asmx.vb file to this: Imports...
17
by: Chris M. Thomasson | last post by:
I use the following technique in all of my C++ projects; here is the example code with error checking omitted for brevity: _________________________________________________________________ /*...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.