want to do Excel "=VLOOKUP(B3;$E$3:$G$11;3;1)" but in SQL

Mario Scheeren7y ago

How can "09" possibly be in that "09100000" and "09199999" range?

AD >= AG AND AD <= AH

First is not true, second is ... so how to compare them - what about their length?

Sorry, but if you do not explain the stuff right, noone can really help you.

+1

Ramon Quintana7y ago

So, in resume:

i want to know if value of camp AD "09" is between range of the camps AG "09100000" and AH "09199999"

I know that Between sentence is used for search values among one range in one camp´s value, but in this case i need to search one value among two camp's values.

Hwo can i to use the Between sentence in this case? or can i use another method?

Thanks..

+1

Mario Scheeren7y ago

I don't know if you are talking about MSSQL T-SQL or MySQL ...

In MSSQL / T-SQL you can use the

CASE WHEN statement to achieve your goal.

+2