Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

How to write this SQL?

Hi all,

The DB has a color field.
When user enters "RED" at a TEdit, then will return some records.
Their fields value is "RED;Blue;Black;" or "RED" or "RED;Blue;".....

How to write this SQL?

Regards, supwang
0
SupWang
Asked:
SupWang
  • 3
  • 2
  • 2
1 Solution
 
kretzschmarCommented:
select * from atable where colorfield like :color

use this code

query1.close;
query1.parambyname('color').AsString := '%'+edit1.text+'%'; //containing or
//query1.parambyname('color').AsString := edit1.text+'%'; //starting with
query1.open;

meikl ;-)

0
 
SupWangAuthor Commented:
Hi meikl,
Why German don?t kill more Israelite? The Israelite is very bad.
Now I very happy to see they be bombed. Those Palestinian hero...
KZ
0
 
ziolkoCommented:
SupWang what the fu** are You talking about, this site is about programming not politics (I didn't see any politics topic around here)
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
kretzschmarCommented:
hmm,
i didn't have anything against the israelite,
and the holocaust was before my lifetime,
even if i don't understand their doing at this time

this isn't a theme for this q

meikl ;-)
0
 
ziolkoCommented:
SupWang meikl is from Germany I'm from Poland this means he should kill me too???
0
 
kretzschmarCommented:
i don't want to kill anyone
0
 
SupWangAuthor Commented:
No. No.  
I means israelite is very bad. always attack their neighbor.
I am a Chinese.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now