Hi,

I need some help doing a simple query. Here is what I have


SELECT Category_Id, Category_name
FROM AG_Category WHERE Auth_Logic_Id = 244
And Category_ID
(
I want category_id to not have a '.' in it. Basically returning
everything above but checking also the category_id so it doesn't return
one where category_id have a . in it
)

Thanks

....
AND category_id NOT LIKE '%.%'

--
David Portas
SQL Server MVP
--