Contractor UK Bulletin Board - View Single Post - SQL to restrict rows by first letter / number

Moscow Mule · 10th July 2008, 12:45

Can you do something like

Select * from bands where subst(band_name:1:1) not exist('ABCDECFGHIJKLMNOPQRSTUVWXYZ')

Syntax is wrong, but you get the idea...

10th July 2008, 12:45	#3
Moscow Mule Super poster Join Date: Mar 2007 Location: London Posts: 3,862	Can you do something like Select * from bands where subst(band_name:1:1) not exist('ABCDECFGHIJKLMNOPQRSTUVWXYZ') Syntax is wrong, but you get the idea... __________________ Level 20 Xeno Geek.