Ring type flash没有微距头怎么玩?# PhotoGear - 摄影器材
L*3
1 楼
Is there anyone can help me this question?
Thanks in advance!
Write a query to parse the order number highlighted in yellow from the
following strings, assuming that the column being parsed is named Column1
and the Table name is TableA:
RWXTR*345724*127BRZU
GHE*2546*4569MRIA
Assume that if an order number exists, the order number is always bounded by
*, but is not always at the same position within the string and the order
number is not always the same length.
Note: the highlighted number is 345724 and 2546
Thanks in advance!
Write a query to parse the order number highlighted in yellow from the
following strings, assuming that the column being parsed is named Column1
and the Table name is TableA:
RWXTR*345724*127BRZU
GHE*2546*4569MRIA
Assume that if an order number exists, the order number is always bounded by
*, but is not always at the same position within the string and the order
number is not always the same length.
Note: the highlighted number is 345724 and 2546