SELECT * FROM user ;
WHERE UPPER(username) = PADR(UPPER(guser), LEN(username)) ;
INTO CURSOR crsRep
>i have a report i am using this query in the report to show the report on the basis of username.
>
>we have a variable guser in our application where the username will get into the guser variable.
>
>if i logged in my name will be in guser = "Raj"
>
>
>How can i use this variable in the query.
>
>
>this is the query i am using:
>
>USER-> USERNAME is equal to guser
>
>Thank you very much.
--sb--