Is it possible to select where a column could contain data like
12, 12A, Unit 12A, 12 Nubby Cottages etc?
What I want is to get only the rows with alpha-numeric data; I don't want just a number, or just a word - has to have both, but the way the data's in the table (or rather a view - I'm doing a query on a view, I believe) there's no structure to it - e.g. number then text... or text then a number.
Is this possible (and how??)
? - MS SQL Server 2005.
12, 12A, Unit 12A, 12 Nubby Cottages etc?
What I want is to get only the rows with alpha-numeric data; I don't want just a number, or just a word - has to have both, but the way the data's in the table (or rather a view - I'm doing a query on a view, I believe) there's no structure to it - e.g. number then text... or text then a number.
Is this possible (and how??)
