Answered
Split Query needed please
Whats the best way to select query of a columns with data
like this:
GBP / USD
The result will look like this:
Cur1 Cur2
GBP USD
GBP / USD
The result will look like this:
Cur1 Cur2
GBP USD
This topic has been closed for replies.
Something like this which will deal with leading and trailing
blanks, miscellaneous blanks between the currency code and slash.
If the slash can be missing this gets more complicated
ltrim(rtrim(substring(curs,1,charindex('/',cur)-1))) as Cur1
rtrim(ltrim(substring(curs,charindex('/',cur)+1,255))) as Cur2
This is really overkill if it's a fixed 3chars space slash 3chars then it's simply
substring(curs,1,3) as Cur1
substring(curs,6,3) as Cur2
ltrim(rtrim(substring(curs,1,charindex('/',cur)-1))) as Cur1
rtrim(ltrim(substring(curs,charindex('/',cur)+1,255))) as Cur2
This is really overkill if it's a fixed 3chars space slash 3chars then it's simply
substring(curs,1,3) as Cur1
substring(curs,6,3) as Cur2
Sign up
Already have an account? Login
To post, reply, or follow discussions, please sign in with your Adobe ID.
Sign inSign in to Adobe Community
To post, reply, or follow discussions, please sign in with your Adobe ID.
Sign inEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices