select error

[elly00]

Hi

I've a select like this:
ObjAdoDbConnection_13.Open IstructionConnectionDatabase_13
ObjAdoDbRecordSet_13.Source = "SELECT * FROM MYTABLE WHERE CODART='"&CODART&"'"
ObjAdoDbRecordSet_13.ActiveConnection = ObjAdoDbConnection_13
ObjAdoDbRecordSet_13.Open

The problem is that if the codart have a ba on it (for example CR/123) the select doesn't work
What can I do in this case?

Thanks