finding char based on ascii value in Ireport

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » finding char based on ascii value in Ireport

finding char based on ascii value in Ireport

Rate Topic

Display Mode

Topic Options

Author

Message

anandhaksc

Posted Tuesday, October 30, 2012 6:27 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, March 28, 2013 3:49 AM
Points: 11, Visits: 17

Dear All,
How to find a ASCII characters based on the ASCII values in Ireport .. Like in Crystal Report Chr(33) used to find ! such things..Please anyone help me and thanks for in Advance..

Regards,
T.AnandhaKsC

Post #1378729

Lowell

Posted Tuesday, October 30, 2012 9:03 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 11,605, Visits: 27,645

You mean like this?

SELECT *
 FROM SomeTable
WHERE SomeColumn LIKE '%' + CHAR(33) + '%'

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1378836

anandhaksc

Posted Tuesday, October 30, 2012 10:46 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, March 28, 2013 3:49 AM
Points: 11, Visits: 17

Yes..But i need in Ireport expression..How to do it..please help me...

Post #1379146

Lowell

Posted Wednesday, October 31, 2012 5:31 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:11 PM
Points: 11,605, Visits: 27,645

anandhaksc (10/30/2012)

Yes..But i need in Ireport expression..How to do it..please help me...

i had not heard of iReport before your post, i was expecting a SQL related question, of course.

i guess you'd probably need to post a question on the IReport website
this seems to be the right place to do it:
http://community.jaspersoft.com/answers

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1379252

« Prev Topic | Next Topic »

Permissions