Hi all! i have 2 strings : fi 1

[popo666]

Hi all!

i have 2 strings :

fileNumber
subFileNumer

subFileNumber is comprised of the fineNumber plus some extra characters

ex. : fileNumber = "123456"
subFileNumber = "123456-1"

my question is, i want to make sure , before recording the subfile number into the db, that the subFileNumber starts with the fileNumber.

i know how to do this in java , but in vba i am clueless

Thx in advance
Fred

 

[dsi]

You can use the InStr() function:

fileNumber = "123456"
subFileNumber = "123456-1"

If InStr(1, subFileNumber, fileNumber) = 1 Then
    'Yes, the Sub File starts with the File No
Else
    'No, it doesn't
End If

 

[popo666]

thx dsi

really helpful

have a nice day

Fred