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
LVL 2
SupWangAsked:
Who is Participating?
 
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
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
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.

All Courses

From novice to tech pro — start learning today.