This was very helpful! Any chance how I can join based on a partial string match? Say in your example, ProjectName('Bike M385 (new)' from Status table had partial string like 'Bike M385' or 'M385' then how would the join be? Do we concatenate the split strings?
Thank you for this very useful video!
it's a very cool and easy solution!! thanks man!!
Glad it helped!
Do you know if this interesting function is in other database?
This was very helpful! Any chance how I can join based on a partial string match? Say in your example, ProjectName('Bike M385 (new)' from Status table had partial string like 'Bike M385' or 'M385' then how would the join be? Do we concatenate the split strings?
Fantastic explanation 🎉
Glad you think so!