optimisteve optimisteve - 1 year ago 67
SQL Question

Identifying records with double space

I am interested in generating a script to identify records under the 'Postcode' column that has double space in between instead of single space.

Table name: Tabu2

Cit_ID DOB Status Postcode
1 12/84 S KT1 3GP
2 11/81 S KT2 2PI
3 13/80 M KT1 2PP
4 15/78 M KT3 2ON
5 13/67 M KT5 4II

Many thanks

Answer Source
Select *
 From Tabu2
 Where Postcode like '%  %'


Select *
 From Tabu2
 Where CharIndex('  ',Postcode)>0

To fix

Update Tabu2 set Postcode=Replace(Postcode,'  ',' ')
 Where  CharIndex('  ',Postcode)>0
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download