Criteria

[Guest]

Hi,

I would like to know what the criteria are. I wanted to pull out the mix
data from the DATA TYPE FIELD.

Ex: The table has COLOR field that DATA TYPE is TEXT
I entered GREEN, RED, BLUE and WHITE in the first row
RED, BLUE, GREEN in the second row
BLUE, GREEN, RED in the third row
It means I will enter fee text in the COLOR field. Therefore, they aren't in
order.

Is there a way that I can put out three colors -Red, blue and green at once?
I tried to use wildcard, but it put out only one color; white or blue or red,
not three of them at once.

Thanks
Chi

 

[Guest]

Are you entering three colors in the COLOR field of a single record?

Post your SQL statement.

 

[Guest]

Yes!

I entered GREEN, RED, BLUE and WHITE in the first record; RED, BLUE, GREEN
in the second record and BLUE, GREEN, RED in the third record

Thanks for your checking.
Chi