by: tomek |
last post by:
What should I write after sql like for finding hole words
and not for words in string sequence. I tryied "like space variable space"
but it's not working for me. Database is MYSQL.
|
by: Mooky Mooksgill |
last post by:
I would like to search a table for a phrase, or for a partial phrase,
eg on table product - for name or description, or name + descprition.
How does one say select * from product where name +...
|
by: Michael Beumers |
last post by:
Hello NG
I've defined a cursor like the following in my COBOL Programm:
DECLARE testc CURSOR FOR
SELECT ...
FROM ...
WHERE
field1 LIKE :hostvariable1
field2 LIKE :hostvariable2
|
by: Tom Walker |
last post by:
I cannot get the WHERE statement to work correctly unless I use a
literal with the LIKE. I want to use a working storage data name so
that I can vary the WHERE statement.
Example that works:
...
|
by: Steve |
last post by:
Hello,
I currently have a query that takes it's criteria from a form. All works
well except when a name is mis-spelled in the database. My thought was to
try to use the "like" command as part of...
|
by: ynott |
last post by:
Novice here obviously. Anyway, I'm a bit confused about how to
approach this. I have a query against a table that I'm trying to
create. I'm trying to view all streets.type values that are null,...
|
by: Nathan Sokalski |
last post by:
I am trying to do a database search using LIKE using the following code:
Private Sub btnSearch_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles btnSearch.Click
If...
|
by: Ed Brown |
last post by:
I'm working on a VB.Net application that needs to do quite a bit of string
pattern matching, and am having problems using the "LIKE" operator to match
the same string twice in the pattern. For...
|
by: Egyd Csaba |
last post by:
Hi All,
I'd like to "compress" the following two filter expressions into one -
assuming that it makes sense regarding query execution performance.
.... where (adate LIKE "2004.01.10 __:30" or...
|
by: Dan Sugalski |
last post by:
Is there any good way to speed up SQL that uses like and has placeholders?
Here's the scoop. I've got a system that uses a lot of pre-generated
SQL with placeholders in it. At runtime these SQL...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, youll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
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...
|
by: Shllpp 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|