Selecting values from SQL 2000

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736602 More actions · Answer 1

SSC Guru

Points: 736602

March 5, 2008 at 7:36 am

Look up charindex in Books Online

Grant Fritchey SSC Guru Points: 398911 More actions · Answer 2

select right('testfolder/test.aspx',len('testfolder/test.aspx') - charindex('/','testfolder/test.aspx'))

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

rasadee SSC Journeyman Points: 79 More actions · Answer 3

ok, this works very well. 🙂

SELECT RIGHT(PageName, LEN(PageName) - CHARINDEX('/', PageName)) AS Expr1

BUT the page names returned has the first letter removed....

why is this??

i am not able to figure that out. please help.

thanks again for your valuable inputs.

Grant Fritchey SSC Guru Points: 398911 More actions · Answer 4

Hmmm, maybe non-printing characters.

See if this returns different values than the LEN statement.

SELECT DATALENGTH('testfolder/test.aspx')

That might be the issue.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

rasadee SSC Journeyman Points: 79 More actions · Answer 5

SELECT DATALENGTH('testfolder/test.aspx') returns one character more than the result dataset.

Which means it is returning the correct number of character.

Why am I not able to print it then?

Grant Fritchey SSC Guru Points: 398911 More actions · Answer 6

If it's one more, then you've got extra stuff in there. Try using DATALENGTH in the query instead & see how that works.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

rasadee SSC Journeyman Points: 79 More actions · Answer 7

SSC Journeyman

Points: 79

March 5, 2008 at 9:45 am

WOW!!!

That works like a charm.

Thank you so much.