Hi,
Here this query gives location of first occurance of letter 'A' in the name.
select
(posstr(t1.NAME,'A')) as Location, t1.Name from vista.VFZPVACCOUNTANT t1
------------ OUTPUT ------------------
LOCATION NAME
----------- --------------------------
0
test 14 Kuhn Handels AG
-------------------------------------
-------------------------------------
I want to select only "Non Zero" location records. Means There should be atleast one 'A' or 'a' in the name.
So that in the output there should be only second record.
I am working on Db2 database Can ne one help.
Thanks in advance,
Dhiraj Srivastava