Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1

Thread: locate

  1. #1
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,992
    Thanks
    120
    Thanked 76 Times in 76 Posts

    locate

    Code:
    select term,locate(' ',term) ,locate(term,' ',1) 
    from table
    -->
    "Arthrocnodax rhoinus Felt, 1908","13","0"

    The last should be 12 or !?....

    ahh forget it, it should be:

    Code:
    select term,locate(' ',term) ,locate(' ',term,1)
    Last edited by BubikolRamios; 01-02-2013 at 12:22 PM.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search


 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •