What is wrong here??

Bryian Tan7y ago

Accepted answer

did you check if there are record in the table based on the between condition?

+3

Ramon Quintana7y ago

Hi Byian good morning

Nothing yet

if i run it without Between sentence it work..

+1

Bryian Tan7y ago

try something like

WHERE Paso1 BETWEEN @AG AND @AH;

+1

Ramon Quintana7y ago

Hi, i changed the syntaxis in the Between sentence like you suggest me but it doesn't work yet,

don´t insert the required data, why?

Question: in The Betwenn sentence can i read Camps instead of values? for example in this case i need to ask if camp Paso1 is among Camp F33 and Camp F34 from my table.

something like: Where camp1 between camp 2 and camp3

intead of: WHERE camp1 BETWEEN value1 AND value2

Thanks..

+1

Amit Kumar7y ago

Hi, you have missing your column name using between keyword. Use like this. Where columnName between Value1 AND Value2

+1

Bryian Tan7y ago

The syntax should be

WHERE column_name BETWEEN value1 AND value2;

@AD (9) doesn't seem like a column name, it a value.

+1

Ramon Quintana7y ago

without clause Between in the Where Sentence the scrip work perfect, but once included the Between clase it doesn't work, why??

+1