how to cast a varchar(50) to sql in teradata with vba

Hi all,

I use excel vba to creat a sql query and get data from Teradata database. Recently the changed a field into alphanumeric and I can't use my query as I get error when passin the customer_id
here are some of the parts:

(I have this in a userform)

Dim clientnr As String
Dim thisql As String
Dim uiValue As Stri
 
clientnr = UserForm3.uiValue.Text


'code where I pass the sql:
thisSql = "CUSTOMER_ID " & _
"FROM myDataBase.CUSTOMER " & _
"Where ((CUSTOMER_ID)= " & clientnr & ")"

the CUSTOMER_ID is set Varchar(50) and is alphanumeric

this really drives me crazy.

Greetings.

Re: how to cast a varchar(50) to sql in teradata with vba

Hi al,

Any possible solution?
I just need to kind of convert or cast the content of the variable "clientnr" to the sql query made via VBA.
I spent hours reading on the Cast in SQL, but I can't figure out how to make use of it.

If some one could point me in the right direction, that would be already great.

Greetings.