convert

[Geetha]

I am looking at a stored procedure written by someone else. Can someone give
me what this means:

SELECT s.svc_ID FROM svc s JOIN #locations ON (CONVERT(VARCHAR, s.facplacesvc)
LIKE '%,' + CONVERT(VARCHAR,#locations.Location) + ',%'
OR s.facplacesvc LIKE 'all')

I do not see a like or = after , "#locations.Location) " before the ',%'

Is it similar to:
select distinct s.svc_id from svc s, temp_svc t
where s.facplacesvc like '%,'
and CONVERT(VARCHAR,t.facplacesvc) = ',%'
or s.facplacesvc like 'all'

Thank you for your help in advance.

[Michael Cole]

Geetha wrote:
> I am looking at a stored procedure written by someone else. Can
> someone give me what this means:
>
> SELECT s.svc_ID FROM svc s JOIN #locations ON (CONVERT(VARCHAR,
> s.facplacesvc) LIKE '%,' + CONVERT(VARCHAR,#locations.Location) + ',%'
> OR s.facplacesvc LIKE 'all')
>
> I do not see a like or = after , "#locations.Location) " before the
> ',%'
>
> Is it similar to:
> select distinct s.svc_id from svc s, temp_svc t
> where s.facplacesvc like '%,'
> and CONVERT(VARCHAR,t.facplacesvc) = ',%'
> or s.facplacesvc like 'all'

No, its basically saying that the join should be the string, facplacesvc,
either contains the string, Location, or is 'all'. % is a wildcard
operator.


--
Regards,

Michael Cole