I was recently given a database that an ex co-worker used to run.
He has a query called
Maketable_namecompare, which creates a table.
In this query he’s running this little bit of sql.
Left(ReturnWord([ProviderName],1),Len(ReturnWord([ProviderName],1))-1)
Is he comparing the left with the len? I’m new to SQL and am having a hard time with this one.
Any help is appreciated!!
He has a query called
Maketable_namecompare, which creates a table.
In this query he’s running this little bit of sql.
Left(ReturnWord([ProviderName],1),Len(ReturnWord([ProviderName],1))-1)
Is he comparing the left with the len? I’m new to SQL and am having a hard time with this one.
Any help is appreciated!!