How to find out second position of any character from a given string

declare @Input varchar(100)
set @Input = '*ashis*kumardas'
select charindex('*',@Input,CHARINDEX('*',@Input,1)+1)

Output: 7


Happy Learning............