SQL Column Value Within string












0















I Have a string below 



100Pipers22WoodfieldRoadBlackpoolFY16AX


I also have an address table on where i want to cross reference the postcode column to see if the value exists in the above string. Column value would be FY16AX which is visible in the string.



I cant seem to get a match.






sql function matching







share|improve this question


















  • 2





    Tag your question with the database you are using. Also, provide the code you have.

    – Gordon Linoff
    Nov 20 '18 at 12:08
















0















I Have a string below 



100Pipers22WoodfieldRoadBlackpoolFY16AX


I also have an address table on where i want to cross reference the postcode column to see if the value exists in the above string. Column value would be FY16AX which is visible in the string.



I cant seem to get a match.






sql function matching







share|improve this question


















  • 2





    Tag your question with the database you are using. Also, provide the code you have.

    – Gordon Linoff
    Nov 20 '18 at 12:08














0












0








0








I Have a string below 



100Pipers22WoodfieldRoadBlackpoolFY16AX


I also have an address table on where i want to cross reference the postcode column to see if the value exists in the above string. Column value would be FY16AX which is visible in the string.



I cant seem to get a match.






sql function matching







share|improve this question














I Have a string below 



100Pipers22WoodfieldRoadBlackpoolFY16AX


I also have an address table on where i want to cross reference the postcode column to see if the value exists in the above string. Column value would be FY16AX which is visible in the string.



I cant seem to get a match.






sql function matching




sql function matching






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 20 '18 at 12:08









Sam ParkySam Parky

196




196








  • 2





    Tag your question with the database you are using. Also, provide the code you have.

    – Gordon Linoff
    Nov 20 '18 at 12:08














  • 2





    Tag your question with the database you are using. Also, provide the code you have.

    – Gordon Linoff
    Nov 20 '18 at 12:08








2




2





Tag your question with the database you are using. Also, provide the code you have.

– Gordon Linoff
Nov 20 '18 at 12:08





Tag your question with the database you are using. Also, provide the code you have.

– Gordon Linoff
Nov 20 '18 at 12:08












2 Answers
2






active

oldest

votes


















1














If I understand correctly, you can use like. In standard SQL, this would look like:



where string like '%' || postcode


The || is the string concatenation operator. Some databases have their own operators or functions for this functionality.






share|improve this answer
























  • Might want to consider case too - e.g. UPPER or LOWER on both your string and search-term (in this case postcode)

    – doublesidedstickytape
    Nov 20 '18 at 12:15






  • 1





    @doublesidedstickytape, better to use a case insensitive collation.

    – jarlh
    Nov 20 '18 at 13:25





















0














Declare @vString nvarchar(50)

Set @vString = '100Pipers22WoodfieldRoadBlackpoolFY16AX'



Select Count(*) From tbl_Address Where Zip = right(@vString,6)


If the select statement returns a value greater than zero, you have a match.






share|improve this answer























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53392691%2fsql-column-value-within-string%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    2 Answers
    2






    active

    oldest

    votes








    2 Answers
    2






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    1














    If I understand correctly, you can use like. In standard SQL, this would look like:



    where string like '%' || postcode


    The || is the string concatenation operator. Some databases have their own operators or functions for this functionality.






    share|improve this answer
























    • Might want to consider case too - e.g. UPPER or LOWER on both your string and search-term (in this case postcode)

      – doublesidedstickytape
      Nov 20 '18 at 12:15






    • 1





      @doublesidedstickytape, better to use a case insensitive collation.

      – jarlh
      Nov 20 '18 at 13:25


















    1














    If I understand correctly, you can use like. In standard SQL, this would look like:



    where string like '%' || postcode


    The || is the string concatenation operator. Some databases have their own operators or functions for this functionality.






    share|improve this answer
























    • Might want to consider case too - e.g. UPPER or LOWER on both your string and search-term (in this case postcode)

      – doublesidedstickytape
      Nov 20 '18 at 12:15






    • 1





      @doublesidedstickytape, better to use a case insensitive collation.

      – jarlh
      Nov 20 '18 at 13:25
















    1












    1








    1







    If I understand correctly, you can use like. In standard SQL, this would look like:



    where string like '%' || postcode


    The || is the string concatenation operator. Some databases have their own operators or functions for this functionality.






    share|improve this answer













    If I understand correctly, you can use like. In standard SQL, this would look like:



    where string like '%' || postcode


    The || is the string concatenation operator. Some databases have their own operators or functions for this functionality.







    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered Nov 20 '18 at 12:09









    Gordon LinoffGordon Linoff

    776k35306409




    776k35306409













    • Might want to consider case too - e.g. UPPER or LOWER on both your string and search-term (in this case postcode)

      – doublesidedstickytape
      Nov 20 '18 at 12:15






    • 1





      @doublesidedstickytape, better to use a case insensitive collation.

      – jarlh
      Nov 20 '18 at 13:25





















    • Might want to consider case too - e.g. UPPER or LOWER on both your string and search-term (in this case postcode)

      – doublesidedstickytape
      Nov 20 '18 at 12:15






    • 1





      @doublesidedstickytape, better to use a case insensitive collation.

      – jarlh
      Nov 20 '18 at 13:25



















    Might want to consider case too - e.g. UPPER or LOWER on both your string and search-term (in this case postcode)

    – doublesidedstickytape
    Nov 20 '18 at 12:15





    Might want to consider case too - e.g. UPPER or LOWER on both your string and search-term (in this case postcode)

    – doublesidedstickytape
    Nov 20 '18 at 12:15




    1




    1





    @doublesidedstickytape, better to use a case insensitive collation.

    – jarlh
    Nov 20 '18 at 13:25







    @doublesidedstickytape, better to use a case insensitive collation.

    – jarlh
    Nov 20 '18 at 13:25















    0














    Declare @vString nvarchar(50)
    
Set @vString = '100Pipers22WoodfieldRoadBlackpoolFY16AX'
    

    
Select Count(*) From tbl_Address Where Zip = right(@vString,6)


    If the select statement returns a value greater than zero, you have a match.






    share|improve this answer




























      0














      Declare @vString nvarchar(50)
      
Set @vString = '100Pipers22WoodfieldRoadBlackpoolFY16AX'
      

      
Select Count(*) From tbl_Address Where Zip = right(@vString,6)


      If the select statement returns a value greater than zero, you have a match.






      share|improve this answer


























        0












        0








        0







        Declare @vString nvarchar(50)
        
Set @vString = '100Pipers22WoodfieldRoadBlackpoolFY16AX'
        

        
Select Count(*) From tbl_Address Where Zip = right(@vString,6)


        If the select statement returns a value greater than zero, you have a match.






        share|improve this answer













        Declare @vString nvarchar(50)
        
Set @vString = '100Pipers22WoodfieldRoadBlackpoolFY16AX'
        

        
Select Count(*) From tbl_Address Where Zip = right(@vString,6)


        If the select statement returns a value greater than zero, you have a match.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 20 '18 at 15:35









        level3looperlevel3looper

        59126




        59126






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid …



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53392691%2fsql-column-value-within-string%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            Popular posts from this blog

            Biblatex bibliography style without URLs when DOI exists (in Overleaf with Zotero bibliography)

            Image
            2 2 I have a Zotero bibliography in Overleaf. I use biblatex . usepackage[backend=biber,citestyle=authoryear]{biblatex} addbibresource{zoteroALH.bib} Bibliography entries look like: @book{de_saint-gervais_uniformization_2016, title = {Uniformization of {Riemann} {Surfaces}}, isbn = {978-3-03719-145-3}, url = {https://www.ems-ph.org/books/book.php?proj_nr=198&srch=series%7Chem}, urldate = {2019-02-03}, author = {de Saint-Gervais, Paul Henri}, year = {2016}, doi = {10.4171/145} } In the bibliography down the paper the reference shows like this: There is the DOI, great, but also the URL which is unnecessary when the DOI is there. How can I remove the URL when the DOI is present? biblatex bibliographies overleaf zote
            Read more

            ComboBox Display Member on multiple fields

            Image
            2 I'm trying to set the .DisplayMember property of a ComboBox in C#, but I want to bind it to multiple columns in the .DataSouce . My SQL looks like this: SELECT PersNbr, PersFirstName, PersMiddleName, PersLastName FROM Pers WHERE PersNbr = :persNbr; I'm saving this query in a DataTable so each column selected has it's own column in the Datatable . I want to make the .DisplayMember a combination of PersFirstName + PersMiddleName + PersLastName so their full name appears like this: comboBox.DisplayMemeber = "PersFirstName" + "PersMiddleName" + "PersLastName" I know I can just to this on the query: SELECT PersNbr, (PersFirstName || PersMiddleName || PersLastName) PersName and then just do this: comboBox.DisplayMember = "PersName"; but I
            Read more

            Is it possible to collect Nectar points via Trainline?

            Image
            2 Since I am not eligible for any Railcard, the only available discount/bonus scheme is Nectar Card for me. GWR, SWR, LNER and Virgin Trains allow to collect Nectar points and I have already linked a card to my GWR account. A friend suggested me to use Trainline App, because it can search for bus tickets either. I had a look at the application, but could not see any option for Nectar. Is there a way to collect Nectar points when I buy tickets via Trainline? uk trains loyalty-programs trainline share | improve this question asked Dec 2 '18 at 15:50 ahmedus 3,224 5 19 49
            Read more