>In VFP, to detect the length of a specific field, I was doing something very simle such as:
>
>

>This.nUsernameLen=LEN(&lcUsernameField)
>This.nPasswordLen=LEN(&lcPasswordField)
>

>
>However, when doing that in Client Server mode, I could either extract one record from the table and achieve the same or would it there be any specific command I would use to detect the lenght of a field?

You can use SQLCOLUMNS() command.