Member Avatar for Pgmer

Hi,
I have my data which looks like '0/1,0/2,0/3,0/4' or '0/1,0/2,0/6,0/3,0/4' I need to select min and max of the
numbers for example for first example my output should be 0/1-0/4 and for second it should be 0/1-0/6.. I am able to get like 0-1 or 0-6.. Any help would be great.. That data will be Varchar.

  • 1 Contributor
  • 1 Reply
  • 112 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by Pgmer
Member Avatar for Pgmer

I wrote a function which splits the charecters which is sent as parameter to it. And used MIN and MAX function which gave me sollution..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.