How to use the MID function using the Query Builder in VB.NET

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ok, I have a Field that has a combination of letter C and a Number that
increments by one.

example:
C1
C2
C3
C4
C5
C6
C7
C9
C9
C10
C11 ...

I would like to find the Maximun number using the query builder. I tried
using the Substring function but it didnt work, I also tried the LEFT and
RIGHT functions but didnt work for me.

I tried using the MID function but it gave an error saying 'MID' is not a
recognized function name.


Please I just would like to find any way to get the highest numer after the
letter.

Example: if I have C1 thru C34 I wold like the query to give me 34 as the
result.

Thanks for any suggestions.
.

Relevant Pages

  • Re: TSPP board repair/modification
    ... I didnt work the first two times I tried, ... Odd. ... Barry - NY ... Prev by Date: ...
    (rec.games.pinball)
  • Re: 6230 Keyguard code crack
    ... > loads of other times today and it didnt work! ... Chris ... Prev by Date: ...
    (uk.telecom.mobile)
  • is there a struts gui plug in for jbossIDE eclipse?
    ... I tried struts-it and tk-struts... ... but they didnt work. ... Prev by Date: ...
    (comp.lang.java.programmer)
  • Re: Pasting Blanks using a macro
    ... this didnt work, it resulted in a few errors. ... TTomSawyer ... TTomSawyer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20511 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • combo box dropdown via code?
    ... Is there a way to get a dropdown combo box to expand via code? ... setting focus but that didnt work. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.compactframework)