01.
USE [DATALAB]
02.
GO
03.
04.
SET ANSI_NULLS ON
05.
GO
06.
SET QUOTED_IDENTIFIER ON
07.
GO
08.
-- =============================================
09.
-- Author: <Author,,Name>
10.
-- Create date: <Create Date,,>
11.
-- Description: <Description,,>
12.
-- =============================================
13.
ALTER PROCEDURE [dbo].[PostCodeByLike]
14.
@Cri varchar(10)
15.
AS
16.
BEGIN
17.
-- SET NOCOUNT ON added to prevent extra result sets from
18.
-- interfering with SELECT statements.
19.
SET NOCOUNT ON;
20.
21.
-- Insert statements
for
procedure here
22.
SELECT * from View_Postcode where View_Postcode.PostCode like
'%'
+@Cri+
'%'
23.
or View_Postcode.Post_Amphur like
'%'
+@Cri+
'%'
24.
or View_Postcode.Post_PostOffice like
'%'
+@Cri+
'%'
25.
or View_Postcode.Post_Province like
'%'
+@Cri+
'%'
26.
END