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.










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.










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.










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






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

            How to change which sound is reproduced for terminal bell?

            Title Spacing in Bjornstrup Chapter, Removing Chapter Number From Contents

            Can I use Tabulator js library in my java Spring + Thymeleaf project?