Link to home
Start Free TrialLog in
Avatar of Angela4eva
Angela4eva

asked on

sql query

I have a table field field called zones

Zones has values like
D4.6.D7
D5.Time
Time.D4
5.D4
D8.D4.D8.9
D8.Time.D6
D5.D5.D5
D4




I want to write a query to have only two values lowest and the greatest

D4--lowest
4
D5
5
D6
6
D7
7
D8
8
D9
9
D10
10--highest

]if there is item called time then it should be the only thing in it.All the other option should be removed.

So the result for above data should be

D4.D7
Time
D4.5
D4.9
Time
D5.D5
D4.D4
ASKER CERTIFIED SOLUTION
Avatar of Sharath S
Sharath S
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
>>So the result for above data should be<<
Not really sure what you're asking. Can you provide an explanation as to how you arrive at those results?