請教各位先進:
我有一個欄位, 分別是由1位數字 2位數字及1位字母 2位數字所組成, 如'101','131','208', 'A43', 'P06'....
如何用Like 的方式將這個欄位第一位是數字or字母給搜尋出來?
我現在用Select * from TABLE Where FIELD like 1__ and like 2__ and ...., 實在是有夠蠢的....

select * from table where left(field1,1) between 'A' and 'Z' or left(field1,1) between '0' and '9'

pedro756901 大大
簡潔的語句, 功力深淺立判
但還是要再請教您
ADOQuery1.SQL.Add('Select * From TABLE);
ADOQuery1.SQL.Add('Where Left(FIELD,1) between A and Z');
or
ADOQuery1.SQL.Add('Select * From TABLE);
ADOQuery1.SQL.Add('Where Left(FIELD,1) ' ' between ' QuotedStr('A') ' and ' QuotedStr('Z'));
都會有語法錯誤的問題, 該怎樣寫才對? 感恩~

===================引 用 文 章===================

select * fromtable where left(field1,1) between 'A' and 'Z' or left(field1,1) between '0' and '9'

adoQuery1.Sql.Add('select * from table ');
adoQuery1.Sql.Add('where left(field1,1) between ''A'' and ''Z'' or left(field1,1) between ''0'' and ''9'');
''是兩個'(單引號)
或
adoQuery1.Sql.Add('where left(field1,1) between ' QuotedStr('A') ' and ' QuotedStr('Z') ' or left(field1,1) between ' QuotedStr('0')' and ' QuotedStr('9'));

完全OK了, 感謝您!!