I'm using SQL Server 2005.
Is there an easy way I can select the numbers between 1 and 10 (or some number) so I get a result set such as:
I don't want to have to do SELECT 1 UNION SELECT 2 etc.
View Complete Post
How to do this:
10 becames 10.00
12.3 becames 12.30
14.23 becames 14.23
my requirement is textbox has to accept only numbers and " ( ) - " symbols only.
any code plz
Has anyone found a solution that will allow me to have page numbers for paging in a data view web part. For instance, if I have 40 items/rows and I set the paging to display 10 items, I'd like the paging to show 1 2 3 4 rather than showing 1-10 and having
to click next over and over to get to a specific item.
I found this article, but it is for 2003 and doesn't seem to apply to 2007 or if it does I am not able to really figure out how.
Thanks in advance.
I need a vb function to determine the last numerical characters in a string. For example, if the string is Step1, I need it to return 1. If the string is Step32, I need it to return 32.
I'm aware of the string functions like Right, Instr, etc but I'm just not sure how to get what I need. Any suggestions?