Why are you limited to using only SQL? Test for an integer? You could use the mod function. mod (number/1) not equal to zero --> number is not an integer. Create a function, pass in the number.