substring Query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • charvi
    New Member
    • May 2007
    • 121

    substring Query

    Hi
    i have problem in query to extract a sub string from a string
    that is i want to extract first name from name
    for eg if i have a name John Smith
    i want to extract John how to extract this can any one suggest me query
    thanks in regards
  • FishVal
    Recognized Expert Specialist
    • Jun 2007
    • 2656

    #2
    [code=sql]
    SELECT Split([FullName], " ")(0) AS FirstName FROM .....;
    [/code]

    Regards.
    Fish

    Comment

    Working...