I have an SQL select that I need to add a WHERE clause to bring back all
records where SeqNo is not a whole number.  Below is my normal SQL without
the WHERE clause.  Thanks.

David

SELECT [ID] ,[SeqNo] ,[FileNumber] ,[Subfile]
  FROM [Filedata].[dbo].[Subfiles]

Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
Convert *= / =* to outer joins (ANSI compliant)
SQL Include Empty Months
2005: How to SELECT a Bitmask?