sort data in grid based on logged in user 1

[sqlpro]

FOLLOWING IS SAMPLE DATA i am showing in a grid

Assid    Staffname    
516	rajani  
518	Alana

here staffname is logged in user name.
is there any way i can show logged in user record as 1st row
in the grid.
in abv example if logged in user is Alana then 1st row
should be

Assid    Staffname    
518	Alana  
516	rajani

by the way the data chnages based different options in the screen.
Thank you very much

cheers

 

[baltman]

depends of the recordsource e.g.

if table
index on MyField [decending] TAG myIdx

if sql
sele * from MyData order by MyField [decending]

 

[sqlpro]

what if data is like

Assid    Staffname    
518    Alana  
516    rajani  
519    Akash

and logged in user is Alana ?


cheers

 

[baltman]

sele *,IIF(user="Alana",0,1) as SortOrder from MyTable order by SortOrder

 

[sqlpro]

Beautiful
cheers

cheers