> 1. If the column-text has 10 or more characters, it should return

just

> the one character at position 10.
> (In Delphi: copy(Text, 10, 1))
>

In Delphi index starts at 0.
but in sql, it seems it starts at 1? because in this case when the
10th place is empty (meaning 1,2,3,4,5,6,7,8,9,10) it returns the
record.

Thanks to Magnus and Thomas for their replies..