Need Help with SQL Statement Please

[LoanB]

Hello

I am writing an address book application.

I want to be able to search for Surnames starting with a particular character let's say "A". The character is getting passed in a String to my business class. I am using Access 2007.

I have: SELECT * FROM Address WHERE Surname LIKE '" + str + "'

But I am getting an Error : Missing Syntax. I know th eabove is incorrect as I only want to retrun record starting with the Character passed.

E.G A return all Surnames starting with A , B return all Surnames starting with B etc.

Any help or recommendations would be greatly appreciated.

Thanks,

Lóan

[MikeTheBike]

Hello

I am writing an address book application.

I want to be able to search for Surnames starting with a particular character let's say "A". The character is getting passed in a String to my business class. I am using Access 2007.

I have: SELECT * FROM Address WHERE Surname LIKE '" + str + "'

But I am getting an Error : Missing Syntax. I know th eabove is incorrect as I only want to retrun record starting with the Character passed.

E.G A return all Surnames starting with A , B return all Surnames starting with B etc.

Any help or recommendations would be greatly appreciated.

Thanks,

Lóan

Hi

Assuming this is in VBA then something like this

SQL = "SELECT * FROM Address WHERE Surname LIKE '" & str & "*'"

?

MTB

[LoanB]

Hi

Thanks for Input.

I'm using C#, Seems right from what I've read, but It return nothing.

Any other clues?

Thanks again,

[LoanB]

Hey Mike,
Just got it.:

sql = "SELECT Surname, Name, Telephone FROM Address WHERE Surname LIKE '" + str + "%'";

Thanks a mil. Your input was they key.

Happy coding,