syntax error near apostrophie

[nikki]

Hi ,
i have a problem when i download supplier codes.I created supplier codes as "andy" and " Y's " .suppliercode andy i can downloaded from database.but Y's i can't.it is saying syntax error near 's'.how can i download the supplier codes which i have created with apostrophie.Plz help me

Thanks

 

[Paszt]

use two apostrophes.

What is supplier codes?

 

[TechGnome]

better still, a parameterized query.... safer and easier.

-tg