Re: [SQL] How to search for a part of a number

2010-10-25 Thread Harald Fuchs
In article <4cc4d3e2.7090...@gmx.net>, Andreas writes: > Hi, > I'm wondering if there was a clever way to find parts of a numeric > string in another table. > There is a table that holds city-codes and city-names. City-code would > be the part of a phone number that identifies the city. > Over he

[SQL] How to search for a part of a number

2010-10-24 Thread Andreas
Hi, I'm wondering if there was a clever way to find parts of a numeric string in another table. There is a table that holds city-codes and city-names. City-code would be the part of a phone number that identifies the city. Over here this code can have 2 - 5 digits. So the table would contain: