Search results for query: *

Sorry, I pasted the wrong code. The code that i used was select (convert(int, BBBB)) as BBBB from Table Name where AAAAAAAAA like '67000%' and CCCC = '2221' and ISNUMERIC(BBBB+'.e0') = 1

@Bborissov: Thanks for the tip. This database was created a long time ago by someone else. I need to use this for my work. Also, I have another question. What if the tab (small box character) is at the beginning of the field, as in instead of "0 99" if it was " 099". The ISNUMERIC(BBBB+'.e0') =...

I need to select the rows other than the row containing 0 99. I need this to find out the average of the column BBBB. I have just provided a small snapshot of the table in my initial post. Thanks

select (convert(int, BBBB)) as BBBB from Table Name where AAAAAAAAA like '67000%' and CCCC = '8033' and BBBB not like '%^[0-9]'

Hi!!! I tried it but I am still getting the same error. Conversion failed when converting the nvarchar value '0 99' to data type int.

Hi, I have been trying to convert nvchar into int but I get this error message "Conversion failed when converting the nvarchar value ' 691' to data type int". There is a meta character before the number 6. It shows as a small box when copied onto text. How do i eliminate this entry? I want to...

Hello, I have a data set (.csv file) which I have split into Test and Training set (using random no generator). There are 7 attributes and a class variable which is nominal with two levels (R and G) List of attributes: There are 2 nominal attributes with 2 levels each and 5 numeric attributes...