I have table with one column(ID), values are in the format of
'123-456-7890'. Now I need to fetch all the rows from the table whose ID values are of the same format.
I tried to query as
Select * from file where ID like ('%___-___-____%').
But no records found.
Kindly let me know, how to acquire this.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!