If the field is a string, rather than numeric, then you could try: select * from tablename where T1_AssetNo = any (44954,44595,44596,44597,44598,44599,44600,44601,44602,44603,44604,44605,44606,44607,44608,44609,44611,44612,44613) or depending on the asset number range, you could use a wildcard: ...
|