Link to home
Start Free TrialLog in
Avatar of bear23
bear23

asked on

sql in vb

I have a 7 field position value and I need to have it sort by the the 5 and 6 character. how can I do this



ex

W123434
F1234336
B123434
h821313
j1234336


would look like this now

W123434
B123434
F1234336
j1234336
h821313

this is in visual basic 6
.


Avatar of bear23
bear23

ASKER

also I will not know if the number or character is, just find the ones that match and put together


ASKER CERTIFIED SOLUTION
Avatar of TimCottee
TimCottee
Flag of United Kingdom of Great Britain and Northern Ireland 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
Avatar of bear23
bear23

ASKER

what does the 5 represent


W123434

the first 4 in the above example

and the 2 meaning

43

???
Avatar of bear23
bear23

ASKER

let me give you another example


w123423
g3432c4
j2132a2
r123425
p3432a4
i1232c4


would look like
w123423     matched by 42
r123425      matched by 42
g3432c4      matched by 2c
i1232c4      matched by 2c
j2132a2     matched by 2a
p3432a4    matched by 2a


Avatar of PreachDotNet
PreachDotNet
Mid(MyField,5,2) Means select the centre of the field (MyField) begin at position 5, for a length of 2 ---
Mid(String,StartPosition,Length)
Don't want any points, Tim answered the question