How to select only values less that 43?

Question

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.

JoseSanchez · Answer

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

TonyContreras_Frisco_TX · Answer

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?