Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 i need to show a double line under a word

Author  Topic 

SqlDevel
Starting Member

18 Posts

Posted - 2005-09-10 : 15:54:24
i nead to show a double line just below a word

is there any upper double line symbol.
i saw a double line but it is in middle.

i am using this symbol with sql.

so i need that symbol to be upper

for example #8254; like this i need a double line symbol

please reply is it possible

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-09-10 : 16:06:28
no it's not.
add the underline in the presentation layer. it shouldn't be that difficult...

Go with the flow & have fun! Else fight the flow
Go to Top of Page

SqlDevel
Starting Member

18 Posts

Posted - 2005-09-10 : 16:09:59
that was quick but did u know that
select replicate('n'®',10)
®®®®®®®®®®

SO THERE IS NO WAY OF GETTING DOUBLE LINE .too bad there is no charmap for that.

it is difficult in my case because of the complexity of my sp and my client requirement.
Go to Top of Page

SqlDevel
Starting Member

18 Posts

Posted - 2005-09-10 : 16:14:37
declare @temp table(vv nvarchar(100))
insert into @temp
select '150000000'
insert into @temp
select replicate(N'¨T',10)
select * from @temp

o/p
150000000
¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T


but this link is in the middle is there charmap for upper double line i am still searching.
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-09-10 : 16:31:46
oh so you can put it in the next line?
i thought you wanted to put it in the same line.
= wouldn't do?
i don't know if such a char exists....

Go with the flow & have fun! Else fight the flow
Go to Top of Page

SqlDevel
Starting Member

18 Posts

Posted - 2005-09-11 : 01:57:00
i even got double low line but no double upper line
declare @temp table (vvv nvarchar(40))
insert into @temp
select 'vasanth 5000'
insert into @temp
select replicate(N'#8215;',10)
select * from @temp
Go to Top of Page

SqlDevel
Starting Member

18 Posts

Posted - 2005-09-11 : 01:58:34
sqlteam 5000
#8215;#8215;#8215;#8215;#8215;#8215;#8215;
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-09-11 : 12:17:16
T-SQL is not a language for formatting ! It stores, manipulates or return DATA -- that's all ! How are you presenting this ? What client app are you using? That is where you do all the formatting you need.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-12 : 00:59:14
This is purely presentation layer issue
You can easily do this in your Front End Application or Reports

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -