Very Computer

In SQL 7, I have a table with field called Narrative.

It contains data as following:

~Acme Industries
XYZ Corp
~~Beck Co.
~~~Union Inc.
~~Tribeca Bros.
~~~~~INCA Inc.
Yem Inc.

What I want to do is put a space after the last tilde (~) in records
that contain tildes.

The result should look like

~ Acme Industries
XYZ Corp
~~ Beck Co.
~~~ Union Inc.
~~ Tribeca Bros.
~~~~~ INCA Inc.
Yem Inc.

Any help is appreciated.

Divyesh

create table #x(ind varchar(500))
insert into #x select '~Acme Industries' union all
select 'XYZ Corp' union all
select '~~Beck Co.' union all
select '~~~Union Inc.' union all
select '~~Tribeca Bros.' union all
select '~~~~~INCA Inc.'

--Required query:

update #x set ind =  left (ind, patindex('%[^~]%', ind) - 1) + ' ' +
right(ind, (len(ind) - patindex('%[^~]%', ind) + 1 ))
where ind like '~%'

select * from #x

--
-Vishal

Quote:> Hi there,

> In SQL 7, I have a table with field called Narrative.

> It contains data as following:

> ~Acme Industries
> XYZ Corp
> ~~Beck Co.
> ~~~Union Inc.
> ~~Tribeca Bros.
> ~~~~~INCA Inc.
> Yem Inc.

> What I want to do is put a space after the last tilde (~) in records
> that contain tildes.

> The result should look like

> ~ Acme Industries
> XYZ Corp
> ~~ Beck Co.
> ~~~ Union Inc.
> ~~ Tribeca Bros.
> ~~~~~ INCA Inc.
> Yem Inc.

> Any help is appreciated.

> Divyesh