Possible compate statement?

[kawai6rr]

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!!

 

[pbaldy]

It would be more accurate to say that he's using the Len() function to help determine the second argument of the Left() function (the number of characters).

 

[kawai6rr]

thanks you!!

 

[pbaldy]

No problemo, and welcome to the site by the way!