Select top 100 NO,replace(LIMIT_N,CHAR(13)+CHAR(10),'')as LIMIT_N
FROM [SALES]
where patindex('%'+CHAR(13)+CHAR(10)+'%',LIMIT_N) > 0
LIMIT_N : 컬럼명
Select top 100 NO,replace(LIMIT_N,CHAR(13)+CHAR(10),'')as LIMIT_N
FROM [SALES]
where patindex('%'+CHAR(13)+CHAR(10)+'%',LIMIT_N) > 0
LIMIT_N : 컬럼명
Copyright © 2024 | WordPress Theme by MH Themes