Discuss "selecting value" in the ASP Development forum.

Hi,

I have a table the design is like this

ID
Description


In description the field can hold values in 2 ways

Tee - Shirt XL
Tee-shirt Size - None


Either the sizes will be S, M, L, XL, XXL, XXXL after Tee - Shirt

What i want to do is check what value the field has

If it has Tee-shirt Size - None then set the strtshirt variable to No Tshirt

If the value is like this Tee - Shirt S or Tee - Shirt M or Tee - Shirt L or Tee - Shirt XL or Tee - Shirt XXL or Tee - Shirt XXXL


then get the shirt size like S, M, L, XL, XXL, XXXL and store it in the variable strtshirt

I am having problems how to query the table and then extract the shirt size


todd

I responded to your question in ASPFree forums. Check there.

I know the table design was poor but it holds 111,000 records I dont have permission to change it thats the problem

Why not use a LIKE query to search for fields that contain "tee" and "shirt":

Then, once you have those, you can use some logic to split apart those strings. Hopefully you will be left with the size.

__________________
"You'll never be as perfect as BLaaaaaaaaarche."