SQL Server 2008 การ SELECT แบบ LIKE % % ใน Query Builder

SELECT column1, column2, ...
FROM table_name
WHERE columnN LIKE pattern

USE [DATALAB]
GO
/****** Object:  StoredProcedure [dbo].[PostCodeByLike]    Script Date: 08/22/2018 15:48:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[PostCodeByLike]
	@Cri varchar(10)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	SELECT * from View_Postcode where View_Postcode.PostCode like '%'[email protected]+'%'
	or View_Postcode.Post_Amphur like '%'[email protected]+'%'
	or View_Postcode.Post_PostOffice like '%'[email protected]+'%'
	or View_Postcode.Post_Province like '%'[email protected]+'%'
END

public partial class frmPostCode_View : Form
    {
        public frmPostCode_View()
        {
            InitializeComponent();
            this.postCodeByLikeDataGridView.SetGridDefaultCellStyle();
        }

        private void fillLikeCriToolStripButton_Click(object sender, EventArgs e)
        {
            try
            {
                this.postCodeByLikeTableAdapter.FillLikeCri(this.dATALAB_Postcode.PostCodeByLike, criToolStripTextBox.Text);
            }
            catch (System.Exception ex)
            {
                System.Windows.Forms.MessageBox.Show(ex.Message);
            }

        }

        private void frmPostCode_View_Load(object sender, EventArgs e)
        {
            this.postCodeByLikeTableAdapter.FillBy(this.dATALAB_Postcode.PostCodeByLike);
        }

      
    }