I have a decimal field. Decimal (18,4)

How can I only select whole numbers from this field or vice versa?

Thanks

Not sure I understand the question fully, but here is a guess.

CREATE TABLE #Trash (t1 DECIMAL(18,4))
INSERT INTO #Trash (t1) values(1)
INSERT INTO #Trash (t1) values(1.1)
INSERT INTO #Trash (t1) values(2)
INSERT INTO #Trash (t1) values(1.9999)
INSERT INTO #Trash (t1) values(2.0001)

SELECT t1
FROM #Trash
WHERE CAST(t1 AS INTEGER) = t1

SELECT t1
FROM #Trash
WHERE CAST(t1 AS INTEGER) <> t1

DROP TABLE #Trash

Payson

Terri wrote:
Show quoteHide quote

SELECT [number] FROM [Numbers]
WHERE FLOOR([number]) = [number]

Should get you the whole numbers.

Show quoteHide quote

Thanks the FLOOR function is wahat I needed.

"Mark Williams" wrote
Show quoteHide quote

Sorry to be so late with this.  Does floor give you what you need with
negative numbers?

Payson

Terri wrote:
Show quoteHide quote

simple insert of strings
Complex Query
adjust my code
avoid using cursors....
really large stored procedures