no, I don't show data, the problem arise because I must order data by a calcutated text field.

My calculated text field si the concatenation of two fields, the second field...

I try it in query analizer but raise sintax error, where is the where clause ?

Can you rewrite the sample query ?

anakin

Thanks, it's right, easy question are always difficult question

here is my page .aspx code:

................

................

Private Sub Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button.Click

Dim strSQL As String = "ip_test"

...

can you write an example of aspx page that use your stored procedure ?

I have tested yours replies but when I run my stored procedure from an aspx page raise an exception and raiserror and return statements are ignored; I have used an...