LPW LPW 21.5: Last Paster Wins

Status
Not open for further replies.

Lara

Well-Known Member
Joined
Jan 23, 2021
Messages
1,659
Not really the place to ask.
Please check if you can get the InStr function to work in an Access query. :(
 

Johnatan56

Well-Known Member
Joined
Jun 22, 2020
Messages
1,530
Location
Vienna
It cant be that bad. Feeling negative is just a state of mind.

I'm sure you can easily change that. :)
Don't worry, planning to run away from the negative environment I am in, tomorrow collecting passport and then can get test done and fill in papers so I can get my flight within 2 weeks.
 

Lara

Well-Known Member
Joined
Jan 23, 2021
Messages
1,659
Don't worry, planning to run away from the negative environment I am in, tomorrow collecting passport and then can get test done and fill in papers so I can get my flight within 2 weeks.
Hope you'll still talk to us when you are far away. :)
 

dabean

Well-Known Member
Joined
Jul 17, 2020
Messages
582
I have a string in the following format:
12346789/2/2021

I would like to extract the number before the first slash. :)

SELECT LEFT('123456789/2/21', INSTR(1,'123456789/2/21','/') -1)
 
Status
Not open for further replies.
Top