SELECT [id_num] ,[LNDID] ,[LNDNO123] ,[LNDNO4] ,[LNDNO5] ,[LNDNO7] ,[LNDARA] ,[LNDUSEA] ,[LNDCHRA] ,[LNDAREA] ,[LNDOID] ,[LND721] ,[LND722] ,[LNDPAR1] ,[LNDPAR2] ,[LNDMEM] ,[LNDONM] ,[LNDHOW] ,[LNDTYPE] ,[EID] ,[RENT] ,[REST] ,[RENT_AREA] ,[RENT_WAREA] ,[CDEXP] ,[PSTNAM] ,[PSTADR] ,[PSTTEL] ,[PRMADR] ,[PSTTELM] FROM [master].[dbo].[101LAND] WHERE (PSTTEL LIKE '%''%')or (PSTTELM LIKE '%''%') or (PSTADR LIKE '%''%') or (PRMADR LIKE '%''%') order by id_num asc
沒有留言:
張貼留言