November 12th, 2012, 11:57 AM
Can anyone please help me with constructing a where statement for the scenario below?
I have a customer table with many columns one of them being an account number. The first three digits of an account number signify branch code. Now I have a branch with a branch code 235 and I want to query for a list of customer in that branch.
How can I construct where statement that is going to read the first three digits of each account number in the customerís table and equate it to 235?
November 12th, 2012, 12:19 PM
November 12th, 2012, 12:25 PM
SUBSTRING will do that, too
December 2nd, 2012, 07:09 AM
i think what cafelatte was trying to say is something like this: