select value in a table

[Bob Bedford]

HI all,

in my sql table I've a list of colors: white, blue, green.....
table colors
idcolor, coloname
1, white
2, blue
3, green.....

I've some programs sending colors for some material, but I don't want to use
them, I'd like to use my values:

example:
program gives 'dark blue' then I'd like to select blue in my table and
return 2...
how to do so ?

Thanks for replying.

[Lixas]

Maybe exploding by space a returned value would help in this case
Bob Bedford raš :

HI all,

in my sql table I've a list of colors: white, blue, green.....
table colors
idcolor, coloname
1, white
2, blue
3, green.....

I've some programs sending colors for some material, but I don't want to use
them, I'd like to use my values:

example:
program gives 'dark blue' then I'd like to select blue in my table and
return 2...
how to do so ?

Thanks for replying.