Possible compate statement? (1 Viewer)

kawai6rr

Registered User.
Local time
Today, 05:28
Joined
Aug 26, 2009
Messages
21
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

Wino Moderator
Staff member
Local time
Today, 05:28
Joined
Aug 30, 2003
Messages
36,118
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

Registered User.
Local time
Today, 05:28
Joined
Aug 26, 2009
Messages
21
thanks you!!
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 05:28
Joined
Aug 30, 2003
Messages
36,118
No problemo, and welcome to the site by the way!
 

Users who are viewing this thread

Top Bottom