Problem due to Case Sensitive query through web services

[j_4jamshaid]

I have deployed an integration interface on Person tables as webservice and search record through against person email. However the search is case sensitive. e.g. the email "myname@mydomain.COM" is not matched due to caps COM though it exists in table. How can i tell Maximo to ignore case while searching through MBO.

Thanks

[amdisuk]

If you can change the sql script you can use the 'lower' key word to compare the lower version of your strings:

Code:

SELECT *
FROM  [dbo].[Courses]
WHERE  LOWER(education_delivery_method)  = 'classroom';

For example.

[amdisuk]

It's fairly easy to do with java code too if you have chance to change that.

[Today]

• How to get list data whic... by kvnaresh [Today at 12:39:03 am]
• How to change an email ad... by kvnaresh [Today at 12:25:57 am]
• Difference between fixpac... by jithu1989 [Yesterday at 05:25:18 am]
• Maximo Programmer Require... by ravikorukonda [February 06, 2012, 05:59:58 pm]
• Demo Maximo 7.1 Online by hyubby [February 06, 2012, 11:05:43 am]
• Error loading the Object ... by G Jeevan [February 06, 2012, 07:21:36 am]
• plzz attribute in another... by Dileep Kumar [February 06, 2012, 07:02:09 am]
• Jpeg attachments within M... by zenagarfield [February 02, 2012, 02:02:53 pm]
• How to change senders ema... by zenagarfield [February 02, 2012, 10:28:06 am]
• Lead and Crew by G Jeevan [February 02, 2012, 07:08:45 am]