Recent content by bhp

very cool thanks :)

Hi very sorry shouldhave been as follows initial if = =IF(AND(Input!A26<>"",Input!B26="Yes"),IF(Input!$G$8="OPTIMIZED",Codelist!A9,IF(Input!$G$6="Quality",Codelist!A9,IF(Input!$G$7="WFM",Codelist!A51,Codelist!A9))),"") and the OR I need to add needs to be as follows...

Hi does anyone know how I simply add in the following OR criteria to the existing IF statement below it??? =IF((AND(Input!B26="Yes",Input!B22="Yes")),Codelist!A111,"")...

Thanks all for help think I can pull together from the different additions, you guys are pretty smart :)

Thanks you have now lost me just looking for a sql query (or pointers) that will return values where 10.1 is higher than 7.6 (understand it is not) thanks - James

Hi thanks played around with and query returned values but I still cannot get it to only return values less than 7.6, i.e. it still returns 10.1.4 in your example. Am obvioudly looking at this the wrong way, thanks for help - James

Hi sorry if being dumb here I cannot find any sql command for split or CINT, many thanks - James

Hi am sure this is easy, can't figure it out. Just need to be able to find values higher or lower. In this case I have to varchar fields with software version in them. I need to know that "10.1.4" is higher than "7.6.2". Note the value can be either "10.1.1" or "10.1" or just "10" Thanks for any...

thanks for super fast response was on similar lines :)

Hi does anyone know if possible to do the following: Have a tabel that has UserName, e.g. "John Smith" and and column called emailaddress which is "jsmith' we want replace all "jsmith" with "John.smith@mycompany.com" Is that possible? Thanks - James

Fantastic new it would be easy was banging my head against wall on that one thank you kindly - James

Hi am sure this is simple can anyone show me how I can can a single row from each name in the following results: Name Domain Open Open>7 Closed Bjoern Diegmann IINFOSYS NULL 3 NULL Bjoern Diegmann IINFOSYS 3 NULL NULL Gareth Hoggins UK NULL NULL 5 Gareth Hoggins...

Excellent thanks v much for help :)

Thanks everyone for help on this much appreciated going to attack another way. Hoping to help more folks on here myself :)

Many thanks but this does not seem to work in my case the field can have 20,000 + characters in it, I just need the last 8000 in each case, this seems to start 8000 characters into the text. I guess my query needs to start at the end and work backwards for 8000 characters? Sorry again if not...