If anyone is a SQL guru then you may be able to help me out. I'm trying to write a SQL query to return IP addresses in the range '10.1.*' - that is, any IP addresses that begin with '10.1.' followed by anything.
However, I believe that entering '10.1.*' as the search criteria in my SQL query will interpret the '.*' as a wildcard rather than taking the '.' before the '*' as a literal character.
So, what should my search string be to take the second '.' as a literal character followed by any characters