convert


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: convert

  1. #1
    Geetha Guest

    convert


    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.

  2. #2
    Michael Cole Guest

    Re: convert

    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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center