B
buke01
I currently have a table of customer information all in upper case, one of
the fields is Address. Is there a way to write a query(s) that will change
each character after a space to UCASE. I know I can change everything to
lower case by using LCASE(addresss). But how is the best way to deal with
the middle strings and convert each first character to upper reguardless of
whether it is preceded by a space, hyphen or dash?
examples:
117 LOYALVILLE-OUTLET RD ==> 117 Loyalville-Outlet Rd
139 OLD STATE RT 25 ==> 139 Old State Rt 25
1 O'NEIL DR SOUTH ==> 1 O'Neil Dr South
the fields is Address. Is there a way to write a query(s) that will change
each character after a space to UCASE. I know I can change everything to
lower case by using LCASE(addresss). But how is the best way to deal with
the middle strings and convert each first character to upper reguardless of
whether it is preceded by a space, hyphen or dash?
examples:
117 LOYALVILLE-OUTLET RD ==> 117 Loyalville-Outlet Rd
139 OLD STATE RT 25 ==> 139 Old State Rt 25
1 O'NEIL DR SOUTH ==> 1 O'Neil Dr South