>Hi all,
>
>I have c:\Bob\01 or c:\Bob\01\ AND I want always
>
>C:\Bob\
>
>How can i do it ?
>
>thank in advance
>
>bernhart
I am not sure if I understood Your question right, but what about:
cBobDir = "c:\Bob\01"
cCBob = LEFT(cBobDir,AT("\",cBobDir,2))
But this will not work well if You use UNC names.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.