Simple Query that is not being co-operative...........

[gaerb]

I am trying to do something real simple and have been pounding my head against the wall for the last hour trying to figure it out.

I need to return all data in a row that doesnt contain a decimal.

I was trying something like this:

Select Col from Tbl where not exists (
Select Col from Tbl where Col contains ".&quot

Keeps popping an error.

Note: this needs to run on both MSSQL Server and Oracle 8/9 i

 

[karluk]

select Col from Tbl where Col not like '%.%'

 

[rac2]

"all data in a row that doesnt contain a decimal"

To get "all data in a row"
SELECT * FROM Tbl

"a row that doesnt contain a decimal"
Well I think rows don't contain decimals.
Rows contain columns perhaps.

And columns contain data.

A column may contain various types of data, numbers and characters. Now while it is true that numbers may contain decimal points, it is false that the values in numerical types of columns contain decimal points. It just looks that way sometimes.

One might store numbers as characters in a column.
In that case karluk has the answer, at least for one column named Col, but what of the other columns? And what if gaerb was talking about the name of the column and not the data at all!

I think karluk found the answer in a book though, I doubt that it came from pounding his head against a wall.

Occasionally MS SQL Server and Oracle will pop error messages that are meaningful. What was that message?