取出表中一字段的头一个字符与所给字符相同的记录,这条sql语句怎么写?

取出表中一字段的头一个字符与所给字符相同的记录,这条sql语句怎么写?
[2 byte] By [uml] at [2007-12-12]
# 1
select .. from .. where substr(zd,1,1)=:zd;
jiazhij-雨中漫步 at 2007-10-24 > top of Msdn China Tech,PowerBuilder,基础类...
# 2
忘了说了,是在数据窗口中,通过retrieve("字符")检索记录
uml at 2007-10-24 > top of Msdn China Tech,PowerBuilder,基础类...