advanced find using sql-queries

[john]

I have trhee questing regarding the sql-editor (find-query).
1
is there a way to use subsets of a string in the where part of the query something like:
select * form t_object where substring(t_object.name,1,2) = substring(t_object.Type,4,2).
NOW I GET AN ERROR
2
same but now the question: can I retrieve the lenght of a string so to say
select * form t_object where substring(t_object.name,1,2) = substring(t_object.Type,length(t_object-Type)-2,2).
I want to compare with the last two characters of the type fields
3
Is there some help page on the features of the sql-editor. I cannot find anything in the help.

[thomaskilian]

Queries are likely limited to DAO functionality. See what Microsoft offers for SQL in MS Access and you'll have th functions that can be used.