String Function in SQL-Substring,Reverse,CharIndex

Suppose You have String "~/ABC/PQR.xxx" in your tables

Now u Want to string PQR.xxx fromm above string

So For That Follow the Steps
1) Open NewQuery Window
2) Paste following Code
declare @str as varchar(200),@str1 as varchar(200),@rev as varchar(200)

set @str ='~/ABC/PQR.xxx'

select @rev = reverse(@str)

SELECT @str1 = CHARINDEX('/', reverse(@str))

select @str1,@rev'@rev',reverse(substring(@rev,0,convert(int,@str1)))


3) Execute the Code
4) You will get the Output Like that PQR.xxx

Comments

  1. Shashank KharcheJune 26, 2010 at 10:47 PM

    This comment has been removed by the author.

    ReplyDelete
  2. Shashank KharcheJune 26, 2010 at 10:48 PM

    Hi Shubhank,

    Good work, but let know the user that the querys ur posting are for which DB. (SQl Server,ORACLE).

    Regards,
    Shashank Kharche

    ReplyDelete
  3. Shubhank Upadhyay - 'Love Your Work Not Your Company'July 19, 2010 at 12:25 AM

    This comment has been removed by the author.

    ReplyDelete
  4. Shubhank Upadhyay - 'Love Your Work Not Your Company'July 19, 2010 at 12:27 AM

    Hi Shashank !

    Thanks for your suggestion.
    I will take care for this in future.

    Regards
    Shubhank Upadhyay

    ReplyDelete
  5. UnknownAugust 20, 2010 at 3:25 AM

    There is Syntax Error in Line "set @str = ~/ABC/PQR.xxx'"

    It must be:

    set @str = '~/ABC/PQR.xxx'

    From,
    BJ

    ReplyDelete
  6. shubhank upadhyayAugust 20, 2010 at 6:15 AM

    Dear Mahotnahi !!

    Thanks for That !


    Regards
    Shubhank Upadhyay

    ReplyDelete
  7. snehaJune 25, 2020 at 2:22 AM

    Your blog is in a convincing manner, thanks for sharing such an information with lots of your effort and time sql server dba online training

    ReplyDelete

Post a Comment

Popular posts from this blog

Difference Between ArrayList and Generic.List C#/VB.Net

Hi, Last few Days, I learnt a very basic and important thing about  that ,When one should go for ArrayList or Generic.List in coding......On basis of that, I found  few difference between both. ArrayList Its comes under System.Collections namespace. Its contains Array of Object.i.e Any objects type we can store in a ArrayList.We can store any no. of objects at runtime. ArrayList aryList= new ArrayList(); // No Need to specify the object type,can store anything arList.Add(1); arList.Add("Shubhank"); arList.Add("False"); We can store any objects in ArrayList and can retrieve only Objects from ArrayList... We can say that ArrayList is not Type-Safe .At the Time of inserting recods ,we can store any type of objects,but at the time of fetching we can't be sure that  Values  which are populate by arList (ArrayList object ) of what type..however.. we have to following code while fetching records/items from Array list foreach(Object o in arList) { ....
Read more

Cloud and How I cleared AZ-900 Microsoft Azure Fundamental exam and Why I choose fundamental

Cloud , what it has & why so much hype ?  for me it was really mystery, I have read , heard everywhere , many techies learning cloud technologies , many companies are migrating their apps on cloud there was so much talks, buzz in townhalls ,webinar , LinkedIn, training institute everywhere cloud, cloud and cloud !!!!  Thumb Rule For every IT engineer, always ready to  learn new skills and add in your Skill Set  hence This time I decided its CLOUD :) I always feel and believe  to implement anything minor/major in your project , get your BASICS rights then implement it and here it is not  case of not CHANGES in apps its MIGRATIONS of apps ! wow big thing really hmm! I am not going to tell definitions/show images of cloud that you will get easily on google ,  thought  to share how I  am learning cloud so First thing I chose  " Lets learn Cloud Fundamental :) " of course no shortcut !!! Well in market  there are so many cloud providers mostly you might have see or even workin
Read more