Alphanumeric paging with DataGrid. SQL wont work

[Andi03]

Hi

 

I have a DataGrid that displays the mebers on my page. I have made a Alpha numeric paging using Query Strings.

 

This is the SQL Im using:

"SELECT ID, Usernamn, Surname & ' ' & Lastnamn As Name, regDatum & ' ' & regTime As Reg FROM tblMembers WHERE Username Like 'A%' ORDER BY Username"

 

It does only display the Usernames that vegins with an big "A" and not the small "a".

 

Ive tried this SQL to correct that but no luck:

"SELECT ID, Usernamn, Surname & ' ' & Lastnamn As Name, regDatum & ' ' & regTime As Reg FROM tblMembers WHERE Username Like 'A%' OR Username Like 'a%' ORDER BY Username"

 

And another problem is that the SQl wont get any other letter either, If I remove the "A" and replace it with the letter "D" then it wont get all the post on letter D. As long as it is the letter "A" then it will get the info but not post that beggins with "a".

 

Can someone help me????

 

//Andi

[pcf108]

Are you sure you're comparing the right field? I see you're selecting Usernamn but comparing Username.

 

Usernamn Like 'A%' ?

 

Otherwise there is no reason why that shouldn't get both Upper and Lowercase names.

[pcf108]

Actually, what database are you using SQL Server 2000? Access?