I need an SQL select query which gives me results when i enter a few characters from a value
SELECT * from Table
WHERE column like Like 'ABC%'
order by XYZ;
Here the value 'ABC' is just a small part of the value and i want to this query to return the results which contain the value 'ABC' in it. For example -- ABC can be present in the server hostname
Hope this helps.