SQL 2008中的SQL查询 [英] SQL queries in sql 2008

问题描述

我怎样才能从字符串中找出文本之前的空格.就像我有字符串
''Shaik̲h̲Cillīkī[即ko] hogayāhaukā/''
现在我必须找出"ki"之前的空间，而"ki"之前是"["之前的空间.
如何在带有字符串的任何文本之前找出空格.
实际上，我只需要在字符串"Shaik̲h̲Cillīkī[即ko] hogayāhaukā/"删除后"kī[i.e. "和]"，即"Shaik̲h̲Cillīko hogayāhaukā/".
任何想法...
谢谢

how can I find out space from string just before text. like I have string
''Shaik̲h̲ Cillī kī [i.e. ko] ho gayā haukā / ''
Now I have to find out space before ''ki'' which is just before of ''[''.
how can find out space just before any text withing string.
actually I need only words within string ''Shaik̲h̲ Cillī kī [i.e. ko] ho gayā haukā / '' after delete '' kī [i.e. '' and '']'' which is ''Shaik̲h̲ Cillī ko ho gayā haukā / '' .
any idea...
Thanks

推荐答案

参考:
T-SQL:标识，插入和删除字符串中的空格 [ ^ ]

Refer:
T-SQL: Identifying, inserting and removing spaces in strings[^]

create function [dbo].[DKAFn_TitleDescription] (@Title as varchar(8000) )

 returns varchar(8000)
as 
begin


declare @result as varchar(8000),
 @desiredString as varchar(250),
 @p as varchar(8000)
--set @p='Shaik̲h̲ Cillī kī [i.e. ko] ho gayā haukā / '
set @p =@Title --'Compete or forfiet! [i.e. forfeit!] :'
--select @p

set @desiredString = replace(reverse(SUBSTRING(@p,1,charindex('[',@p,1))),
substring(reverse(SUBSTRING(@p,1,charindex('[',@p,1))),1,charindex(' ' ,reverse(SUBSTRING(@p,1,charindex('[',@p,1))),1)),
'')--replace first space of reverse string

if  charindex(' ' ,@desiredString,1)=0 
begin
set @p=replace (@p,reverse(@desiredString),'')
end
else
begin
 set @desiredString = SUBSTRING (@desiredString,1,charindex(' ' ,@desiredString,1))--pickup upto second space

 set @p=replace (@p,reverse(@desiredString),'')
end
set @p=replace(@p,'[','')
set @p=replace(@p,'i.e. ','')
set @p=replace(@p,']','')

set @result=replace(@p,']','')


return @result


  
END

这篇关于SQL 2008中的SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！