Post reply

Trim Name in MS Access

  • September 25, 2014 at 7:04 am

    #293707

    Hi All,

    I am very new to MS Access. I have list of names like this in a column in my access and would need to trim the names like below.

    Names:

    Clooney, George Timothy

    Willam Pitt, Brad

    Wilson, Larry

    Expected Output:

    Clooney, George

    Willam, Brad

    Wilson, Larry

    I need to have the first word before and after the comma. Also on top of this I need to add a space after comma.

    Really appreciate suggestions.

  • September 25, 2014 at 7:21 am

    #1748148

    This is a forum for SQL server. Many queries for SQL are not compatible with MS Access. You will have better and more accurate respons if you post your question in a MS Access forum.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply