Search results for query: *

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...

Hi thanks fro response but that gives me the FIRST 8000 characters. e.g if I wanted the last 5 digits when the text in the field was "football is great" I only want to return the word "great" in this case. I need to return the LAST 8000 characters, sorry if not being clear, thanks - James

Hi does anyone now how to return the last 8000 characters from a ntext field I guess you would use reverse in some fashion? Any help greatly appreciated as giving me a headache :) Thanks - James

Or Simply use the DTS wizard in sql server and use an odbc connection the only thing you need to do is install the MYSQL drivers !!!

Hi Thanks for the response but not sure how you could add the notes field together for each ID with a select ? i.e. select ID, Note would only return all rows I do not have any criteria just that for each ID all the note daat for that ID must be displayed. thanks!!!

Hi I have 2 columns from a table as follows: ID(int) Note(ntext) 10 dsdadasdasdsdads ewrewr 10 asdsdsdasdasdasd 10 sdsa 11 cvxvcvxvcxvcvx cxvcxvxv 11 frfwefwfwr wrfrw rw wr 4 opeiqwei 4 wqwdqdedd 4 eeweqeq All I...