Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 689
  • Last Modified:

remove space - sql - access

Hi experts, can you please help to remove the first space (using sql query-access) coming after the comma of all data in a table field Full_NAME, here comma is coming in between the last name and first name.
The names in the column looks like as follows,
Tharoor, Sasi
George, Mathew T
Thomas, Obama L.
0
gtmathewDallas
Asked:
gtmathewDallas
1 Solution
 
Rey Obrero (Capricorn1)Commented:
you can use an update query, back up your table first

update tableName
set [Full_NAME]=replace([Full_NAME] & ", ",", ",",")

if you are sure that all names have comma, you can use

update tableName
set [Full_NAME]=replace([Full_NAME],", ",",")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now