I have a field with
Z/N/2016062/11
in a table.
What would be the best way to get Z and N through a select statement?
@LEFT( B_REF, @SCAN( B_REF, '/' ) ) give me Z but how to get the N?
Tokenise
Re: Tokenise
@LEFT( B_REF, @SCAN( B_REF, '/' ) ) || @MID( B_REF, @SCAN( B_REF, '/' )+1, 1 )
gives you ZN
gives you ZN
Re: Tokenise
Unfortunately the lengths of the first and second tokens is not 1. @LEFT works for the first token, but @MID assumes the length of 1.
B/BB/2016057/42556
B/BB/2016057/42556
Who is online
Users browsing this forum: No registered users and 4 guests