Mr_Shaw
asked on
Is it possible for a query distinguish between 'London Bridge' and 'London Bridge'
Is it possible for a query distinguish between 'London Bridge' and 'London Bridge'
There are two spaces between London and Bridge?
There are two spaces between London and Bridge?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
True...
It is just the suffix white spaces
select 'same'
where 'london bridge'='london bridge '
select 'same'
where 'london bridge'='london bridge'
It is just the suffix white spaces
select 'same'
where 'london bridge'='london bridge '
select 'same'
where 'london bridge'='london bridge'
ASKER
thanks
thanks
ASKER
WHERE Location ='Asia'
WHERE Location ='Asia '
The are treated the same.