Hi all,
I have a connection to Teradata with VBA. First part of the query is to get all records that starts with the first letter of a customer name:
Code:
WHERE FRNAME like 'M%'
this works great when hard coded.
I have a text field where I fill in the first letter, and there is a variable called "FirstNameLetter" I tried things like:
Code:
Where ((FORENAME)= '" & FirstNameLetter & " %')"
and I only get errors.
Any clue where I go wrong? I will also need for the address field that has:
Code:
AND (ADDR_LINE_2 like '%WEXFORD%' OR ADDR_LINE_3 like '%WEXFORD%' OR ADDR_LINE_4 like '%WEXFORD%')
Greetings.