Guys! See the Sybase query below: select convert(float,sub...

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by pathfinder
Submitted on 8/12/2003
Related FAQ: Sybase FAQ: 9/19 - ASE Admin (6 of 7)
Rating:	Rate this question:
Guys! See the Sybase query below: select convert(float,substring(<field1>,3, charindex('/',<field1>) -3 )) from table I want to modify this such that, if '/' exists in <field1>, then as above. Else, instead of charindex('/',<field1>), I need to use datalength(<field1>) Is there anyway that I can include everything in one statement?

Answer by Netaman
Submitted on 11/5/2004
Rating: Not yet rated	Rate this answer:
add a case statement around convert and only convert when not isnull.. ie select sys_a, case when isnull(ltrim(rtrim(substring(sys_a,charindex('/',sys_a)+4,2))),'NA') = 'NA' then 0 else convert(int,ltrim(rtrim(substring(sys_a,charindex('/',sys_a)+4,2)))) end from table this might work

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: