I think you've confused some syntax.
Best way to do this is
SELECT My_Fields[,,,,] FROM My_Table WHERE number LIKE '123%' OR number LIKE '456%';
This will work for
VARCHARs, but not for
'%LIKE%' doesn't exist, unless you're trying to pick out the string
'LIKE' from a longer string.
A search for the string - LIKE %123% makes no sense - it has to be between two single quotes - i.e. like LIKE '%123%';
If the string you're searching for is "embedded" in the phone number string - i.e. it's
VARCHAR(25) - or similar - and you're searching for
'01-24-123...', then your search string is non-sargable which can lead to significant performance hits.
To search within the string, use LIKE '%123%' - but, as I've said, it will not use indexes - check out the URL I've referenced for sargable.
All of this should be carefully analysed before system launch - unless you have only a couple of thousand records.
I was in College and the Library had introduced a new cataloguing system - you could be there minutes before a search came up for this very reason, - I told the librarian that this was a basic mistake and that the people who designed the system should be shot - she replied, "No, that would be too good for them!" :-)