Searching for data that has an int 1

[mbcmike]

I have a table, where I only want to select the sets of data that contain an integer. I thought about using CONTAIN, but that wouldn't work because it is for data with characters. Also, I don't want to search for specific integers, just if the data has any int in it at all.

For example:
(a) Height: 67
(b) Height

Only (a) would be selected here because it contains an int

 

[Jamfool]

select * from tbl
where column like '%[0-9]%'

pattern searching in books online.