To add to what Dave has said...
The LIKE operator only works with strings: so even if you corrected your mistake and store numbers in numeric columns - which you really must do - SWL would convert them back to strings to do a LIKE comparison.
But even then, there is no built in operator that will compare the numbers 4.5 and 4 and give you a "these are identical" result.
Your choices (once your DB design is corrected) are to convert the numbers to integers using the
SQL Server CAST() Function[
^] which will discard any fractional part, or use a range:
...WHERE x BETWEEN 4.0 AND 4.99999
You must change your DB first though: Always use the appropriate datatype for storage. Numbers in numeric fields (INT, FLOAT, DECIMAL). Dates in date based columns (DATE, DATETIME, DATETIME2). And you need to modify your presentation software to work with them - which means validating and converting inputs before INSERTing or UPDATEing the DB by passing the converted values as parameters.
If you don't, you are storing up some major problems for yourself: invalid data, mixed format data, and SQL Injection are the major worries.