How to select only values less that 43?

[JoseSanchez]

Good afternoon

, concat('SequenceNo=', ${proposed_meter_sequence}, ' and ', ${proposed_meter_sequence}, '<=43' ))

I am looking for a way to select   proposed_meter_sequence values that are less than 43.  I tried the  syntax above but it does not work.

Please advise.

[TonyContreras_Frisco_TX]

The concat function is for text data, which cannot accurately be compared to numeric data. Is the proposed_meter_sequence column stored as integer or text?

[JoseSanchez]

Hi @TonyContreras_Frisco_TX 

The proposed_meter_sequence column is stored as an integer.  In this case how do I only select values  <= 43?

Thanks