Can you guys plz help me on this....
i need to convert any text and number of textbox1 in reverse in textbox2
but my problem is i need to convert numeric in english word.
for example:
user input textbox1 = abc123
output on textbox2 should be threetwoonecba
any help will be appriciated!!!

thank you in advance

Here how U can do it.
Create a table where you will store world for the numbers (0 to 9).
Then use the reverse function. When ever you hit the number go to the table and convert it.

It will work for sure.

GOOD luck

first of all put the letter in for loop, something like

for i = len(InPut) to 1 step -1
then use RIGHT function to extract the last letter
use if statement, if letter = 1 then "One" -- I think u can use REPLACE function as well
concatenate and accumulate it in a output variable
next i

I don't really know VB that well, but giving you a logic. THere could be tons of other logic to accomplish this.

Goodluck

HERE IS how I did with sql procedure.
I guess the logic is the same for VB as well. CHECK IT OUT.
--********
-- table to hold number and word for 0-9
Create table dbo.bsNtoT
(Num int,
Word varchar(20)
)

--insert script for lookup table
insert into dbo.bsNtoT values (0,'zero')
insert into dbo.bsNtoT values (1,'one')
insert into dbo.bsNtoT values (2,'two')
insert into dbo.bsNtoT values (3,'three')
insert into dbo.bsNtoT values (4,'four')
insert into dbo.bsNtoT values (5,'five')
insert into dbo.bsNtoT values (6,'six')
insert into dbo.bsNtoT values (7,'seven')
insert into dbo.bsNtoT values (8,'eight')
insert into dbo.bsNtoT values (9,'nine')

--Create procedure do the job
ALTER procedure bsReverse
(
@input varchar(20)
)
as
begin
Declare @i int, @Count int, @iLen int
Declare @NewText varchar(10), @Text varchar(10), @FinalText varchar(100), @check char(1)
set @i=1
SET @FinalText=''
SELECT @Count=len(@input)
SELECT @iLen=@Count
WHILE @i<=@Count
begin
SELECT @NewText=substring(@input,@iLen,1)
SELECT @check= isnumeric(@NewText)
if @check='1'
SELECT @NewText=Word FROM dbo.bsNtoT WHERE Num=@NewText

SELECT @FinalText=@FinalText+@NewText
SET @i=@i+1
SET @iLen=@iLen-1
end

SELECT @FinalText
end


--try running it
exec bsReverse 'ab45c'


--********