Re: Return or Select Partial String value

From: Rohtash Kapoor (rohtash_nospam_at_sqlmantra.com)
Date: 05/13/04

  • Next message: scmiles: "Re: Return or Select Partial String value" 
    Date: Thu, 13 May 2004 08:10:49 -0700

    CREATE TABLE #Temp_First
    (
      Num VARCHAR(20)
    )

    CREATE TABLE #Temp_Second
    (
      Num VARCHAR(40),
      Des VARCHAR(40)
    )

    INSERT INTO #Temp_First VALUES ('11111')
    INSERT INTO #Temp_First VALUES ('44444')
    INSERT INTO #Temp_First VALUES ('55555')

    INSERT INTO #Temp_Second VALUES ('www.domain.com/11111','comment1')
    INSERT INTO #Temp_Second VALUES ('www.domain.com/44444','comment2')
    INSERT INTO #Temp_Second VALUES ('www.domain.com/55555','comment3')

    SELECT * FROM
      #Temp_First
      JOIN #Temp_Second
      ON #Temp_Second.num LIKE '%' + #Temp_First.num 

    ---
Rohtash Kapoor
http://www.sqlmantra.com
"scmiles" <anonymous@discussions.microsoft.com> wrote in message
news:cb3001c438f8$ca6ecb40$a301280a@phx.gbl...
> I need a SELECT query that can compare/match a string
> value, example, tableX.number = '12345' from tableX, to
> tableY.URL = 'http://www.domain.com/folder/name-12345'
>
> so the WHERE clause can match the two by the full value
> of tableX.number to the partial value at the end of
> tableY.URL
>
> Any help appreciated
> Thanks
  • Next message: scmiles: "Re: Return or Select Partial String value"

    Relevant Pages

    • Return or Select Partial String value
      ... I need a SELECT query that can compare/match a string ... value, example, tableX.number = '12345' from tableX, to ... so the WHERE clause can match the two by the full value ...
      (microsoft.public.sqlserver.mseq)
    • Re: OpenForm with Where Clause
      ... So how would I do a pattern match on a field that had data like DMH10257 or ... Dim strWhere As String ... of unbound search controls on different types of fields, ... about the Like condition in the where clause? ...
      (comp.databases.ms-access)
    • Re: How to open a report based on a multi-select listBox
      ... "build" as the WHERE clause from your multiselect listbox might look ... DoCmd.OpenReport "ReportName",,, strWhere ... Dim strWhere_Field1 As String, strWhere_Field2 As String ... >> method to pass the filtering string. ...
      (microsoft.public.access.formscoding)
    • Re: How to OpenRecordset(queryName refering to form)
      ... Yes, you can store the where clause in the table field, but when it's read in the code it will indeed be treated a string - stupid of me. ... It is still possible to do it in a similar fashion, though more complicated: you would need a separate table with a one to many relationship to the forms, one record per field to filter on with fields for FormName, FieldName, FormCOntrolName and type; then you would need to open this table as a recordset in your code, filtering on the form name, and loop through the records constructing the Where clause. ... Alternatively, you could use a convention like: no additional table, all the info for fields to filter on comes from the form itself: for all fields you wish to filter on, name the corresponding control on the form with a perfix followed by the field name, then loop in your code through the form controls and add to the where clause string for those controls starting fltr, extracting the field name from the control name -4)...). ...
      (microsoft.public.access.queries)
    • Re: The mystery of the missing (compound) variables.
      ... its line (so I can recover it as a number) and a following space- ... separated text string line which can be PARSEd. ... to the second last END clause. ... other than READY  the THEN LEAVE clause passes control to the second ...
      (comp.lang.rexx)