[DB] Access問題

幫幫手填下[...]
select xxx from xxx [...]

select fieldA as fa from TableA as ta where fa LIKE
'a%';

LIKE 可以搵到個field ge pattern
LIKE 'a%' 即係搵到a 字開頭ge 所有pattern
同樣...可以LIKE '%a' or '%a%'..
前者會找到所有a 字結尾的字串...如1234a, 123a, 2a, a etc
後者則搵到所以字串中包括a 字的...如1234a, 123a, 123ab, a1234, a, etc..
仲可以 LIKE 'a_';
即係a 字開頭後EXACTLY 一個字的字串先會搵到...如a1,a2, etc... a12 就唔包括了,,

select xxx from xxx where (((databasename.fieldname) Like "a*"));