I need to display only those items which contains lower alphabets??
Hw can i achieve that

Hi,

Do you need to display items which contain ONLY / ANY lower case letters?

In both cases you should use the query.extend.where() funtion (http://www.baanboard.com/programmers_manual_baanerp_help_functions_sql_query_extensions_query_extend_where) or the skip.io() function (http://www.baanboard.com/programmers_manual_baanerp_help_functions_db_operations_skip_io)

I hope it helps,

- George

I need to select any lower case .....I need to knw the how write that lower case thing

Here is an example of a function that returns true if the item contains a lower case

function domain tcbool item.con.lower(domain tcitem item)
{
long i
domain tcbool item.contains.lower

item.contains.lower = false
for i=1 to len(item)
if item(i;1)>= "a" and item(i;1) <= "z" then
item.contains.lower = true
endif
endfor

return(item.contains.lower)
}

I hope it helps,

Nomally the item codes are upper case only . Probably u want to search any abnormally created item codes . U can use like operator in tools query with comparision string " *.*[a-z].*" (for any small case character ) and " *[a-z]*" (for all small characters) . U can use like along with query extension also .