Professional Web Applications Themes

What is equivalent to instrRev() function of VB-6 in Sql 2K ? - Microsoft SQL / MS SQL Server

What is equivalent to instrRev() function of VB-6 in Sql 2K ? For example: Retrieving last dot position from 2.2.5.4.3 which is : 8 Best Regards, Luqmn...

  1. #1

    Default What is equivalent to instrRev() function of VB-6 in Sql 2K ?

    What is equivalent to instrRev() function of VB-6 in Sql 2K ?

    For example:

    Retrieving last dot position from 2.2.5.4.3 which is : 8

    Best Regards,

    Luqmn








    Luqman Guest

  2. #2

    Default Re: What is equivalent to instrRev() function of VB-6 in Sql 2K ?

    You can do:

    SELECT LEN(s) + 1 - CHARINDEX('.', REVERSE(s))

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Sen Guest

Similar Threads

  1. "between" function equivalent in Perl?
    By Alexandra in forum PERL Miscellaneous
    Replies: 35
    Last Post: September 16th, 06:03 AM
  2. equivalent of php function decbin
    By Thomas Theakanath in forum PERL Miscellaneous
    Replies: 2
    Last Post: September 15th, 04:43 PM
  3. PHP equivalent to MOD
    By James Johnson in forum PHP Development
    Replies: 1
    Last Post: August 30th, 07:27 PM
  4. php equivalent of CGI.pm
    By pittendrigh in forum PHP Development
    Replies: 1
    Last Post: August 19th, 02:45 PM
  5. ACT! Equivalent for Mac?
    By compuser in forum Mac Applications & Software
    Replies: 2
    Last Post: July 10th, 05:34 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139